Loading

Error Connecting to SQL Sever 2005

Eric

18y2.9k

I am getting this error when I try to connect using the SqlConnection object:

An error has occured 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 conncetion to SQL Server)

What do I need to change or do in order to programmatically connect to a database?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijaya Kadiyala18y ago
Hi,

check out the below link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=192622&SiteID=1

Thanks -- Vj

http://dotnetvj.blogspot.com
Scott Lysle18y ago
http://forums.asp.net/p/1209227/2135169.aspx#2135169

Might help you out.