July 24, 2015 at 8:09 am
Hello, I have a Windows 2008 R2 cluster with two nodes and 5 SQL Server 2008 R2 instances running on it. I need to uninstall one of the instances but the SQL Services (only SQL Server and Agent) won't start. I have started the process to remove a node from the cluster under Maintenance of the Installation center. I can select the instance so setup can see it and both nodes, but I'm curious if the uninstaller will attempt to start the services and then fail because the services won't start.
Do the services need to be running and able to be started in order to successfully uninstall?
The cluster errors when I try to start the SQL Server service from the cluster manager are:
Cluster resource 'SQL Server (XXXXXXX)' in clustered service or application 'SQL Server (XXXXXXX) (A Node)' failed.
The application event log shows:
Could not register Service Control Handler. Operating system error = 2310(This shared resource does not exist.).
[sqsrvres] StartResourceService: Failed to start MSSQL$XXXXXXX service. CurrentState: 1
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 435)
[sqsrvres] OnlineThread: Error 435 bringing resource online.
The service doesn't even get far enough along to log any messages in the SQL ERRORLOG.
Thanks!
July 26, 2015 at 10:23 am
shawnjohnson (7/24/2015)
I have started the process to remove a node from the cluster under Maintenance of the Installation center. I can select the instance so setup can see it and both nodes, but I'm curious if the uninstaller will attempt to start the services and then fail because the services won't start.Do the services need to be running and able to be started in order to successfully uninstall?
No, when running the uninstall on a passive node the services will not be started anyway
shawnjohnson (7/24/2015)
The cluster errors when I try to start the SQL Server service from the cluster manager are:Cluster resource 'SQL Server (XXXXXXX)' in clustered service or application 'SQL Server (XXXXXXX) (A Node)' failed.
The application event log shows:
Could not register Service Control Handler. Operating system error = 2310(This shared resource does not exist.).
[sqsrvres] StartResourceService: Failed to start MSSQL$XXXXXXX service. CurrentState: 1
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 435)
[sqsrvres] OnlineThread: Error 435 bringing resource online.
The service doesn't even get far enough along to log any messages in the SQL ERRORLOG.
Thanks!
Do all the other resources in the group come online successfully?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 27, 2015 at 5:41 am
Hi Perry,
Thanks for the reply.
Do the services need to start on the active node? I am removing this instance from the cluster (uninstall on both nodes) and didn't know if at some point the services needed to start to update sys.dm_os_cluster_nodes.
Yes, the virtual server name, IP address and disk resources all come online. Just SQL Server and SQL Server agent do not start.
July 30, 2015 at 4:37 am
shawnjohnson (7/27/2015)
Do the services need to start on the active node? I am removing this instance from the cluster (uninstall on both nodes) and didn't know if at some point the services needed to start to update sys.dm_os_cluster_nodes.
I've actually never bothered to check, have you tried running the uninstall?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2015 at 5:01 am
I have not ran the uninstall. I postponed the removal and have to get another maintenance window for the work, but will post the results once complete.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply