Keep up to date with the latest information about Microsfot Dynamics GP through articles from the Perfect Image and azurecurve blog.
How To Install Microsoft SQL Server 2016: SSIS Configuration For Named Instances
February 2nd, 2017 by Ian Grieve
This is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.
In the last post, I installed SSIS, but if you are using a named Instance of SQL Server, there is a configuration step required.
To make the change, there is a file called MsDtsSrvr.ini which, for SQL Server 2016, is located in C:Program FilesMicrosoft SQL Server130DTSBinn. The ServerName needs to be changed to include the full SQL Server Instance Name (as highlighted below):
Once the full SQL Server Instance Name was added and the file saved, SSIS is ready to use.
|How To Install Microsoft SQL Server 2016|
|Installing SQL Server Database Engine|
|Configuring SQL Server Reporting Services|
|Installing SQL Server Analysis Services|
|Installing SQL Server Integration Services|
|SSIS Configuration For Named Instances|