Sql Connection Error!!!
-
Hi All, I am trying to open connection to Sql database server through an ASP.net application using an Ip address. connstrr="Data Source=111.11.111.20;Initial Catalog=TestData;User ID=Testdate;Password=Test" I get the following error on my ASP.net code Connection.open() line.. 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) Can any one advice me what is the problem? Thank you
-
Hi All, I am trying to open connection to Sql database server through an ASP.net application using an Ip address. connstrr="Data Source=111.11.111.20;Initial Catalog=TestData;User ID=Testdate;Password=Test" I get the following error on my ASP.net code Connection.open() line.. 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) Can any one advice me what is the problem? Thank you
kibromg wrote:
connstrr="Data Source=111.11.111.20;Initial Catalog=TestData;User ID=Testdate;Password=Test"
Are you accessing local system or any remotes system server ? What is the SQL Server version ? is it SQL Server EXpress Edition ?
Best Regards ----------------- Abhijit Jana View My Latest Article :- SpyNet : Your Network Spy "Success is Journey it's not a destination"
-
Hi All, I am trying to open connection to Sql database server through an ASP.net application using an Ip address. connstrr="Data Source=111.11.111.20;Initial Catalog=TestData;User ID=Testdate;Password=Test" I get the following error on my ASP.net code Connection.open() line.. 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) Can any one advice me what is the problem? Thank you
This is a very common error. By default SS2005 does not permit remote connections. A quick google of this error should provide some guides as to how to use the surface area configuration stuff.
-
kibromg wrote:
connstrr="Data Source=111.11.111.20;Initial Catalog=TestData;User ID=Testdate;Password=Test"
Are you accessing local system or any remotes system server ? What is the SQL Server version ? is it SQL Server EXpress Edition ?
Best Regards ----------------- Abhijit Jana View My Latest Article :- SpyNet : Your Network Spy "Success is Journey it's not a destination"
-
Thank you for your response. I am using SQL2005 and accessing it remote server. Thank you
is it SQL SERVER Express Edition ?
Best Regards ----------------- Abhijit Jana View My Latest Article :- SpyNet : Your Network Spy "Success is Journey it's not a destination"
-
is it SQL SERVER Express Edition ?
Best Regards ----------------- Abhijit Jana View My Latest Article :- SpyNet : Your Network Spy "Success is Journey it's not a destination"
-
Hi All, I am trying to open connection to Sql database server through an ASP.net application using an Ip address. connstrr="Data Source=111.11.111.20;Initial Catalog=TestData;User ID=Testdate;Password=Test" I get the following error on my ASP.net code Connection.open() line.. 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) Can any one advice me what is the problem? Thank you
Check this out http://support.microsoft.com/kb/914277[^]
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson