SQL Server 2005 Problem

[kcwallace]

I am trying to begin upgrading to SQL Server 2005 from 2000. I am using the developers 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

 

[PlausiblyDamp]

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).

 

[kcwallace]

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.