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())

Is the default Instance and the named instance running in the same domain account context? Also, most people that use clustering would just use named instances...

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

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:
Driver][DBNETLIB]SQL Server does not exist or access
denied.
Driver][DBNETLIB]ConnectionOpen (Connect()).

I am sorry but I don't fully understand your question. Please give more details for us to help you with you qs.

You said "I have two w2k3 servers set up as active/passive cluster. Is it possible to set up an active/active cluster on the two SQL2K servers for them". I am assuming you
have two node w2k3 active/passive cluster. Active/passive meaning one node of the cluster has all the resources available, while the other node is idle and waiting in
case of a failover. Is that what you mean? What resources do you have on the active node?

Also you want o set up an active/active cluster on the two SQL2K server? Do you mean by this that you want one instance of SQL2K virtual server on each node? If yes,
then yes - you can set up acive/active cluster with one instance of sql 2k server.


Here is a link to Microsoft SQL 2K Failover Clustering whitepaper that will give you more information

SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp


Feel free to ask any related qs that you may have. Please give as much details as possible to get a better answer.


Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx