SQL Connection Error

anjumathi kumar

15y2.9kSQL

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) "

Hi, while connecting sql server from one machine to another machine i get like this error how to resolve?

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vilas Gite15y ago
Hi

Check this: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

---------------------------------------------------------------------------------------------------

If this reply hepls your post…then "MARK AS ANSWER"!

0
Abhimanyu K Vatsa15y ago
You should check following:

1. Make sure your database engine is configured to accept remote connections
•Start > All Programs > SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration
•Click on Surface Area Configuration for Services and Connections
•Select the instance that is having a problem > Database Engine > Remote Connections
•Enable local and remote connections
•Restart instance

2. Check the SQL Server service account
•If you are not using a domain account as a service account (for example if you are using NETWORK SERVICE), you may want to switch this first before proceeding

3. If you are using a named SQL Server instance, make sure you are using that instance name in your connection strings in your ASweb P.NET application
•Usually the format needed to specify the database server is machinename\instancename
•Check your connection string as well

4.You may need to create an exception on the firewall for the SQL Server instance and port you are using
•Start > Run > Firewall.cpl
•Click on exceptions tab
•Add the sqlservr.exe (typically located in C:\Program Files (x86)\Microsoft SQL Server\MSSQL.x\MSSQL\Binn), and port (default is 1433)
•Check your connection string as well

5. If you are using a named SQL Server instance, make sure you are using that instance name in your connection strings

6. Check SQLBrowser; check that it is running. You may also need to create an exception in your firewall for SQLBrowser.

7. Check that you have connectivity to the SQL Server. Note what you are using to connect: machine name, domain name or IP address? Use this when checking connectivity. For example if you are using myserver
•Start > Run > cmd
•netstat -ano| findstr 1433
•telnet myserver 1433
•ping -a myserver

Check what ports are IP addresses are being returned.
0
Suthish Nair15y ago
How to find correct connection string:

Find Database Connection and Generate Connection String using Visual Studio

0
Priya Linge15y ago
Hi,

Please check below link,

http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/

I hope it will help you.

Thanks.
0
Jiteendra Sampathirao15y ago
please provide the connection string once....then we can find where you went wrong.....
0
Krishna Garad15y ago
Make sure
1) Both server & client system are connected to each other.
2) Make sure the server system is started not swiched off.
0
anjumathi kumar15y ago
I provide correct ip address only..eventhough getting same error
0
Krishna Garad15y ago
Provide valid server name and credential. It's the error cause of wrong server name you can provide IP address of the server system also here.
0