How To Install Microsoft SQL Server 2016: SSIS Configuration For Named Instances

February 2nd, 2017 by

Microsoft Dynamics GPThis 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):

MsDtsSrvr.ini file in Notepad

Once the full SQL Server Instance Name was added and the file saved, SSIS is ready to use.

Click to show/hide the How To Install Microsoft SQL Server 2016 Series Index

Read original post How To Install Microsoft SQL Server 2016: SSIS Configuration For Named Instances at azurecurve|Ramblings of a Dynamics GP Consultant

Source: azurecurve

Leave a Reply