Hi, Have you check to make sure you got Named Pipe enabled for the SQL Server instance for Network Configuration, which can be set in SQL Server Configuration Manager. Hope this helps. J.

Hello All, I am having a problem accessing the stored packages - MSDB folder on my system. I am running SQL 2005 SP3 on a Windows 7 system for testing. I have created an export package that confirms that it has completed and have told it to store the package on the SQL Server. I can log into my Integration Service but when I click on Stored Packages and then MSDB the system thinks a while and then returns the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: Login timeout expired An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, 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]. (Microsoft SQL Native Client) I am logged in to the Integration Service with the same login as I was in the Engine. Any suggestions? Regards, Rob

Hi Rob, If the SQL Server 2005 instance is not a default instance but a named instance, I think you need to modify the ServerName element in the SSIS configuration file. Please refer to the following threads: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/59fdf431-9cfc-4ecd-9001-71f65e50e27b/ http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/3f0c8abc-fb6b-41a1-8c46-577b8f2a01a8/ Please remember to mark the replies as answers if they help and unmark them if they provide no help. Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.