SQL Connection Error -- "Provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified"
Hi,
SQL Connection Error -- "Provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified"
Solution. Check any one solution from below points.
2) Make sure your instance name is correct and there is actually such an instance on your target machine.
3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).
4) Make sure SQL Browser service is running on the server. (This one is worked for me)
5) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.
SQL Connection Error -- "Provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified"
Solution. Check any one solution from below points.
1) Make sure your server name is correct, e.g., no typo on the name.
3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).
4) Make sure SQL Browser service is running on the server. (This one is worked for me)
5) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.
Comments
Post a Comment