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.”
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…
Change the value of ServerName to your SQL Server clustered instance name.
This step should be repeated on any other nodes where SSIS is running.