Configuring SSIS to non default instance

If you are running SSIS on a server without a default instance, you may have seen the following error when attempting to use Object explorer in SSMS to view packages:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

The SQL Server specified in Integration Services service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer

This happens because the configuration file for SSIS has a local instance as the default configuration.

The location of the configuration file by default for SQL Server 2008 is here:

C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml


    <Folder xsi:type="SqlServerFolder">

To change to a named instance, insert the instance details in the xml config file:

    <Folder xsi:type="SqlServerFolder">

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: