SQL Cluster Remove

Giganews Newsgroups
Subject: SQL Cluster Remove
Posted by:  Alex (al…@rogers.com)
Date: Thu, 13 Jul 2006

Hi,

I need to remove SQL 2000 from an old Windows 2003 (No SP) Active/ Passive
cluster system which has not been used in long time and install SQL 2005
instead.
Before removing SQL 2000, I tried to bring SQL Server resource online but it
failed with following errors in application event log:

[sqsrvres] OnlineThread: Error 422 bringing resource online.
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 422)
[sqsrvres] StartResourceService: StartService (MSSQLSERVER) failed.  Error:
422

Screenshot of Cluster administrator is attached.

Is there a way to safely bring SQL 2000 cluster resource online and then
remove it all together or just remove SQL 2000 from both nodes?

Thanks

Replies