problem in connecting with Sql server express 2005 provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
-
Hi I'm using Visual web developer 2005 with Sql server express 2005 edition. I'm not able to connect to Sql server express 2005 although I'm able to connect to the same using oSql command line utility. I get the following error using the Visual web developer.
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I tried searching on the Ineternet for the same and applied with different combinations but problem persists. Please advise Thanks in advance!
Don't Quit
-
Hi I'm using Visual web developer 2005 with Sql server express 2005 edition. I'm not able to connect to Sql server express 2005 although I'm able to connect to the same using oSql command line utility. I get the following error using the Visual web developer.
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I tried searching on the Ineternet for the same and applied with different combinations but problem persists. Please advise Thanks in advance!
Don't Quit
If you have enabled remote connections, this is probably firewall which is blocking the connections.
All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions
-
If you have enabled remote connections, this is probably firewall which is blocking the connections.
All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions
N a v a n e e t h wrote:
If you have enabled remote connections, this is probably firewall which is blocking the connections.
Hi, Firstly both visual web dev and Sql server express 2005 are on same system. Secondly Firewall is turned off. Any clues????? :zzz: Thanks
Don't Quit