kcwallace Posted July 13, 2006 Posted July 13, 2006 I am trying to begin upgrading to SQL Server 2005 from 2000. I am using the developer's edition locally on my PC. Everything works fine. However when I publish to a intranet location, I get the following error. 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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Can some provide me some guidance Quote Go Beavs!!!
Administrators PlausiblyDamp Posted July 13, 2006 Administrators Posted July 13, 2006 If you run the SQL Server configuratuon manager tool and expand the SQL Server 2005 Network Configuration node you should see a list of the installed protocols. If the only one enabled is shared memory you will need to enable at least one of the others (in most cases TCP/IP should do the trick). Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
kcwallace Posted July 13, 2006 Author Posted July 13, 2006 THank you. I was just about to post the retraction to my previous post. I figured out what you said to do on my own. Quote Go Beavs!!!
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.