title: BizTalk 2016 Missing Sql Management Tools
body: <p>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.</p>
  
  <p><a href="https://i.stack.imgur.com/ZieKD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZieKD.png" alt="enter image description here"></a></p>
  
  <p>So, at this point I go to Sandro's blog post to remind me what I missed: <a href="https://blog.sandro-pereira.com/2011/08/31/biztalk-2010-bam-tools-configuration-error-microsoft-sql-server-data-transformation-services-dts-2008-with-sp1-or-higher-for-bam-archiving-is-not-installed-on-the-local-machine/" rel="nofollow noreferrer">Sandro's Post</a></p>
  
  <p>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:</p>
  
  <p><a href="https://i.stack.imgur.com/LobfV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LobfV.png" alt="Options Missing"></a></p>
  
  <p>So, I go back to the 1st page of the Wizard and Notice the Option for "Install SQL Server Management Tools":</p>
  
  <p><a href="https://i.stack.imgur.com/6Gnrn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6Gnrn.png" alt="Page1"></a></p>
  
  <p>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.</p>
  
  <p>Does anyone know what I can install on the BizTalk application server to get around this problem?</p>