Failed Node Need to rebuild

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Murray - 22 Nov 2006 16:09 GMT

I am having an issue with the primary node of our SQL 2005 x64 Cluster
(Windows2003EnterpriseEditionx64). After installing SP1 I am getting the
below error when the service tries to start.

So obviously I messed up something during the upgrade. So decided to write
this node off and try and reinstall SQL. Unfortunately it will not
uninstall because it can not see the quorum drive even though it really is
there. Obviously I can not move the group because the service is failed.
How can I for uninstall SQL to try and rebuild the node? Has anyone seen
this issue before? I would rather not rebuild the OS if possible. It is
only SQL that is failing the rest of the box it working great.

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 11/22/2006
Time: 8:33:48 AM
User: N/A
Computer: SQL001A
Description:
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).

Reply to this Message

Sporter - 22 Nov 2006 20:27 GMT

Hi Tim,

I ran into a similar issue when working on SQL 20056 clusters in my lab. I
did find a link that was very useful when trying to uninstall a node manually.

Take a look at this one and let me know if it helps;
http://msdn2.microsoft.com/en-US/library/ms180973.aspx

Regards,

Sporter

> I am having an issue with the primary node of our SQL 2005 x64 Cluster
> (Windows2003EnterpriseEditionx64). After installing SP1 I am getting the
[quoted text clipped - 19 lines]
> The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 17058 (0x42A2).

Reply to this Message