Click here to Skip to main content
15,923,083 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am getting the following error,

provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
Posted
Updated 23-Apr-15 1:28am
v2

Seems like you need to check your connectionstring.

Good luck!
 
Share this answer
 
Steps for determining the problem can be found in this CodeProject article Solution: Error: 26 – Error Locating Server/Instance Specified[^]

Further information from this MSDN blog[^]
 
Share this answer
 
This error is raised if an error is raise while connecting to the server. The few of the possible reasons for this can be,


  1. Server name is not valid; typo?
  2. If the database is remote, make sure connection is still established.
  3. Firewall might be intervening between your and the server.


You can take the above points as check list and make sure all of these are not causing any problem at all in your system. Usually the first one causes the problem, make sure you are having the correct server-name in your connection string so that the framework is trying to connect to the correct server; available server.

Apart from this, I found a few threads from Microsoft Forums which might guide you through.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8cdc71eb-6929-4ae8-a5a8-c1f461bd61b4/provider-sql-network-interfaces-error-26-error-locating-serverinstance-specified?forum=sqlexpress[^] (Forum Thread)
http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx[^] (Blog post)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900