Recently, we have started moving our MSSQL production databases to another server which has multiple instances of SQL server.
I've been trying to get things to connect from a .NET web app with little success.
I found a great blog post which has been updated over time to include more details regarding the exact issue I've encountered.
http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx
One potential issue is with the port used to communicate between the web and SQL server. Instances ...