Monday, March 19, 2012

Failed Node Need to rebuild

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).
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
"Tim Murray" wrote:

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

No comments:

Post a Comment