4. May 2007 05:17
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.