Hi I have just reinstalled .Net and SqlServer2005. I am running my application from local machine and sqlserver is also install local machine. but when I run application. Get follwing Error Message
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)
What was the application trying to do when you got this message? It may be that the connection string is not correct, it may be that the server is setup for only windows authentication.
|||Hi
From your description, it seems that you met error when you are trying to connect to your SQLServer,right?
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)
For this kind of issue, we should use the following steps to diagnose the problem.
First, you also should make sure that if 1433 port has been enabled on your server, which is the default port for SQLServer remote connections.
Generally, you can try the following ways to handle your problem.
1. Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition
2. Enable the SQL Server Browser service
3. Create exceptions in Windows Firewall
4. Create an exception for SQL Server 2005 in Windows Firewall
5. Create an exception for the SQL Server Browser service in Windows Firewall
More details for each step, you may see the following link:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
Thanks.
No comments:
Post a Comment