Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Rebuild and Instance creation - failing failover

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-15 : 07:54:57
David writes "We have an Active Active cluster, sql2000 sp4. SAN disk presentation is setup correct. We had to rebuild 1 node of the cluster, so our second node has all the instances and is running properly. When we rebuilt the first node, installed SQL, got one instance installed, it worked fine, when we get the second instance installed, it installs without issue, when we try to fail over our second instance from node 2 to node 1, it fails when loading the sql instance name. The disk moves over, the IP moves over, all of the dependancies move over, but the SQL named instance is failing with

The description for Event ID ( 17052 ) in Source ( MSSQL$USAGCHIDLDB15 ) 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] OnlineThread: RegOpenKeyExW failed (status 2).

Any ideas?

Thanks."
   

- Advertisement -