Error Connecting to SQL Sever 2005

Question

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?

Vijaya Kadiyala · Answer

Hi check out the below link http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=192622&SiteID=1 Thanks -- Vj http://dotnetvj.blogspot.com

Scott Lysle · Answer

http://forums.asp.net/p/1209227/2135169.aspx#2135169 Might help you out.