ASP.NET 2.0-SQLEXPRESS 2005 Connection Problem

i got an error just like that.What must i do?

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)

Does your ASP.NET user account have rights to access SQL server?

If yes you should look for your message in forum I saw one post about how to configure server to allow remote connections

Thanks

|||

http://ambarishganguly.blogspot.com/2006/12/remote-connections-to-sql-server-2005.html

and also restart the SQL Server Browser will allow remote connections

|||

Are you running this on your local computer or a hosted site?

If this error happens on your local server, your SQL Express service is probably not running or you did some funky configuration

If this error happens on a hosted site, your hoster probably do not support SQL Express and you need to update the connection information to point to a SQL server.

|||

Dearibrahimersoy

Which SqlServer do u use in your web 2000 or 2005 ?. Can u show your web.config here ?

|||

Hi,

This error might be cuased that SQL Server does not allow remote connections. Because by default, this is not enabled.

To solve this problem, you can follow the instructions on the following KB article.

http://support.microsoft.com/kb/914277/en-us

HTH.