July 4, 2007 at 10:59 pm
I log into the Integration Serverices Server and I try to expand the MSDB folder where I have some SSIS packages stored in the MSDB Database but i get the error below. Why? I don't understand!
The SQL server specified in SSIS 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 Server 2005 Books Online.
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]. (MsDtsSrvr)
July 4, 2007 at 11:12 pm
Is your sql server instance an named instance? The remote connections error you get is when the remote connections options is not opted in configuration manager.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 4, 2007 at 11:26 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply