August 13, 2007 at 5:56 pm
Thank you for your help.
I am running SQL Server 2005 Standard ed. I am new to SQL and I am trying to deploy a SSIS package that I created in SQL Server Business Intelligence Development Studio. I go through the deployment process fine but when I go into SQL Server Management Studio I can connect Integration Services. The problem is when I try to go to Stored Packages > MSDB I am getting an error saying, “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.
VIA Provider: The specified module could not be found. (Microsoft SQL Native Client)”
I have gone through and allowed remote connections and the protocols for the server and the native client, and restarted the services
I have inserted the server name into the MsDtsSrvr.ini.xml file, but I am still getting the error, I also tried the IP with no success.
Could any of this have to do with the fact that this is all on my machine and not on a server somewhere or because I am on a domain?
Thank you again
August 14, 2007 at 3:33 am
Do yu have more than one instance of SQL running? Use Server\instance.
August 14, 2007 at 9:12 am
No I just have the one instance running on the machine
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply