Labels

Sunday, 10 January 2016

SQL DBA : Error 26 Error Locating Server / Instance specified .

The reason for throwing this error could be Wrong Server Name , Disabled remote connections , firewall blocking , SQL Server browser services were stopped .

Work Around 

1. Make sure the server on which SQL Server is running can be accessible ? 

2. Make sure the server name is reachable by pinging command from command prompt .

3. Make sure SQL Server browser services are running .

4. Corresponding TCP / IP port or pipe is not specified in the connection string .

5. If firewall is enabled on the server then you need to put sqlbrowser.exe and / or UDP port 1434 into exception .

No comments:

Post a Comment