Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Data Services (SSDS)

Interview Question :: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL

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)

I am getting this error while running a web service from VS2005 and connecting sql server 2000. I do not want to connect sql server 2005 . I have enabled TCP/IP, NP and have checked allthe ports also. But still I am getting this error. Any idea why?

Answers to "When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL"

RE: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL?
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 default settings SQL server does not allow remote connection. ( provider: Named Pipes Provider, error: 40 - could not open a connection to SQL server. ) Fix/Workaround/Solution: http://blog.sqlauthority.com/2007/04/23/...
Vote for this answer ::

RE: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL?
I have put the server name in the datasourse rather than the IP address and it solved the problem. Report Abuse
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Data Services (SSDS)

Interview Question :: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL

Top Tags