I am trying to install an Active/Active cluster of SQL2000 on a Win2003 machine. I installed the default instance and a named instance. When both instances are on the same machine, they come up correctly. However, if I fail the named instance over to the other node, it will not come up. If I then fail the default instance over to the other node the named instances starts. The error messages are as follows

[sqsrvres] ODBC sqldriverconnect faile

[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

[sqsrvres] ODBC sqldriverconnect faile

[sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())

Are the service account passwords the same on both machines? What are the
steps you took to install both virtual servers?

--

Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

I was just wondering if you got anywhere on this? We are
having a similar problem, not quite the same. We have 2
named instances, they both work fine on node1, but on
node2 only one will come online. The error we get in the
event log are the same as you are getting.

JOHN

[quoted text, click to view]
SQL2000 on a Win2003 machine. I installed the default
instance and a named instance. When both instances are on
the same machine, they come up correctly. However, if I
fail the named instance over to the other node, it will
not come up. If I then fail the default instance over to
the other node the named instances starts. The error
messages are as follows:
[quoted text, click to view]
native error = 11; message = [Microsoft][ODBC SQL Server
Driver][DBNETLIB]SQL Server does not exist or access
denied.
[quoted text, click to view]
native error = 35; message = [Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen (Connect()).
[quoted text, click to view]