Error 40
-
Hi Friends, While I am trying to connect to the database server I am getting the following error. 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) I checked my web.config file. I didnt find any errors in this. Please help me to solve this. I am using VS 2005 and SQL Server 2000 Thank you Jijo
JIJO BABY - Lets Play C#
-
Hi Friends, While I am trying to connect to the database server I am getting the following error. 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) I checked my web.config file. I didnt find any errors in this. Please help me to solve this. I am using VS 2005 and SQL Server 2000 Thank you Jijo
JIJO BABY - Lets Play C#
Hi, In the error it is given -
jijobaby wrote:
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
And you have not mentioned that whether the SQL Server you want to use is on same machine or LAN some where. If you are using a network SQL Server then this error may occur because the TCP/IP or Named Pipes may not be set in ur SQL Server. Please specify the complete details about the location of SQL Server.
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
Anant Y. Kulkarni
-
Hi, In the error it is given -
jijobaby wrote:
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
And you have not mentioned that whether the SQL Server you want to use is on same machine or LAN some where. If you are using a network SQL Server then this error may occur because the TCP/IP or Named Pipes may not be set in ur SQL Server. Please specify the complete details about the location of SQL Server.
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
Anant Y. Kulkarni