Jonas Stawski

Everything .NET and More

Error: 26 - Error Locating Server/Instance Specified

If you're trying to connect to a named instance database on the network (that is not locally) then by default you will get the error specified on the title. You can solve this in 2 ways:

1. Enabling the TCP/IP protocol on the server machine and specifying a static port and then creating an alias on the client machine (that is your local/development machine) and pointing to the same port.

2. If you don't have SQL Server installed on your dev/local machine then you can start the SQL Server Browser service on the server and enable the TCP/IP protocol and that will also do the trick.

Happy programming!

Add comment