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)


Exception Details: System.Data.SqlClient.SqlException: 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)

Source Error:

Line 46: Dim dsJobSite As DataSet
Line 47:
Line 48: sqlDBConn.Open()
Line 49:
Line 50: dsJobSite = New DataSet("JobSite")

Source File: c:\inetpub\wwwroot\JIEditor\MainMenu.aspx.vb Line: 48

My ASP.NET 2.0 applicaton is running on a Windows 2000 Server with IIS 5.0. MDAC 2.6

Also, both Names Pipes and TCP/IP protocols are enabled.

Please help me connect to the database.

Isa Paine


Isa Paine
Software Developer

I have the same the problem. Any suggestions?