Active/Active Clustering Issue | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Active/Active Clustering Issue

Hello Everyone, We’re trying to set up an active/active SQL 2K (32-bit) cluster on a Windows 2K3 64-bit environment. I was able to successfully setup the first node (Node1). When I install SQL on the second node (Node2Node2), its erroring out with a lot ODBC unable to connect messages. Below is a sample of the message: The description for Event ID ( 17052 ) in Source ( MSSQL$CL1DBS07 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Has anyone seen this? Thank you in advance for your assistance.
Follow the procedure outlined here: Installation of a named instance of SQL Server 2000 virtual server on a Windows 2003-based cluster fails