Because your SQL Servers are in active/active, I assumed you have one default inatance and one named instance. you are able to access the default instance that uses TCP port 1433. The named instance is using another TCP port which you acn find it from SQL Server errorlog. You can work around by creating alias with client network utility in your client machine with the correct TCP port number and connect it with the alias.

Make sure you use correct SQL Server virtual server name.

Have you tried to connect it with virtual IP address?

Edited by - Allen_Cui on 06/04/2003 07:10:39 AM