Connect to SSIS on Named Instance of SQL Server
I am encountering this error on a freshly installed Named Instance SQL Server 2005
"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. For more information,
see the topic "Configuring the Integration Services Service" in SQL
Server 2008 Books Online.
Login Timeout Expired
An
error has occurred while establishing a connection to the server. When
connecting to SQL Server 2008, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote
connections.
Named Pipes Provider: Could not open a
connection to SQL Server [2]. (MsDtsSvr)."
after googling I found this blog post from http://www.igregor.net
http://www.igregor.net/post/2009/01/21/Connect-to-SSIS-on-Named-Instance-of-SQL-Server.aspx
Works like a charm =)