Recently I encountered an exception while trying to connect to SQL Server named instance. We have a main server with SQL Server 2005 installed on as the default instance and another SQL Server 2008 installed as a named instance. The connection string I used was: " Data Source=ServerName\InstanceName,1433;network library=dbmssocn;Initial Catalog=MyDataBaseName;Integrated security=SSPI " We are using TCP/IP as the underlying connection method in order to connect to SQL Server. This can be...