SSIS in a Failover Cluster: Failed to retrieve data for this request

I got this error when attempting to expand the msdb ssis package store on my recently built test cluster;

"Failed to retrieve data for this request.

Additional information:

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

ssis_cluster_error

We need to alter the ssis configuration file, when working in a clustered SQL Server environment, as the service is unable to find an instance of SQL to connect to. The default location of this file is C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml. open the file and you will see something like below…

conf1

Change the value of ServerName to your SQL Server clustered instance name.

conf2

This step should be repeated on any other nodes where SSIS is running.


Leave a Reply