Search code examples
biztalkbiztalk-2016

BizTalk 2016 Missing Sql Management Tools

I'm configuring a new BizTalk 2016 install, Sql 2016 is installed on a separate server. I get the usual error re missing integration services.

enter image description here

So, at this point I go to Sandro's blog post to remind me what I missed: Sandro's Post

Problem is, the resolution no longer applies because the option for "Management Tools - Basic" / "Management Tools - Complete" is no longer an option, from the Sql Server 2016 Setup Wizard:

Options Missing

So, I go back to the 1st page of the Wizard and Notice the Option for "Install SQL Server Management Tools":

Page1

Trouble is, clicking this just attempts to navigate to a page on the web, to download SSMS v17.4. There is no internet connectivity out from this BizTalk server. So, I download from a laptop then get SSMS v17.4 installed onto the BizTalk server. I then restart the BizTalk configuration application (import my previously saved config and re-enter all the passwords!), this does not help with SSIS problem.

Does anyone know what I can install on the BizTalk application server to get around this problem?

Solution

  • Problem was, BizTalk config not happy with the version of SSMS had been installed. Solution was to remove v17.4 then download v16.5.3 from the following and install it: Microsoft Download