Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Instance not selectable when trying to remove node from a cluster Expand / Collapse
Author
Message
Posted Thursday, May 27, 2010 3:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 5:06 PM
Points: 42, Visits: 272
Hi All, I have installed SQL on one of the nodes of a 2 node cluster but it failed, this was due to the service account not being a local admin, thought it was a member of the AD group that was a local admin. Anyway, I granted permission to that group, but still couldn't add the second node, because of the error after I installed. I can get the instance it is running, but there is no SQL agent present. I Tried a repair but that didn't work, so I decided to remove the node through the setup, but the instance does not appear, there is nothing in the dropdown list. Never seen that before. I have located this article

http://msdn.microsoft.com/en-us/library/ms180973(SQL.90).aspx

Not sure about this, but it is an option.

http://magmainteractive.net/weblogs/post/SQL-Server-2008-November-CTP-Uninstall-Headaches.aspx

This is probably not applipacable to a cluster.

Any advice appreciated

Any advise would be appreciated.
Post #928822
Posted Thursday, May 27, 2010 11:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 6,191, Visits: 13,340
which version of SQL Server are you attempting to cluster?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #929184
Posted Thursday, May 27, 2010 4:52 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 5:06 PM
Points: 42, Visits: 272
It's all 2008R2 OS and SQL
Post #929365
Posted Friday, May 28, 2010 4:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 6,191, Visits: 13,340
when you get the error

are you creating a failover cluster instance or adding a node to a failover cluster instance


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #929558
Posted Thursday, June 10, 2010 6:59 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 5:06 PM
Points: 42, Visits: 272
I got it sorted, I decided to proceed with my cluster build and it seems that installing another instance resolved the issue, I got it uninstalled successfully. My recommendation. DON'T install SQL 08 on WIN 08 in a 2000 domain, wasn't my choice. The customer is always right.
Post #935800
Posted Wednesday, May 22, 2013 5:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 6, 2013 2:54 AM
Points: 4, Visits: 21
We have two SQL servers configured as a failover cluster. One of them is a physical and the other is a VM.
Occasionally we are having problems with this, as the node tries to failover eventhough the cluster operations are disabled.
Our goal is virtualize the physical SQL server and remove the failover cluster functionality.
The problem is while trying to uninstall the cluster, the instance does not appear in the drop down.
How can we uninstall the cluster and proceed with virtualizing the physical server?

Thanks,
Post #1455431
Posted Wednesday, May 22, 2013 4:54 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 6,191, Visits: 13,340
arun.zakaria (5/22/2013)
We have two SQL servers configured as a failover cluster. One of them is a physical and the other is a VM.

Perfectly reasonable I don't see any issue here.


arun.zakaria (5/22/2013)
Occasionally we are having problems with this, as the node tries to failover eventhough the cluster operations are disabled.

What exactly do you mean here, please explain what you have done\disabled?


arun.zakaria (5/22/2013)

Our goal is virtualize the physical SQL server and remove the failover cluster functionality.
The problem is while trying to uninstall the cluster, the instance does not appear in the drop down.
How can we uninstall the cluster and proceed with virtualizing the physical server?

Thanks,

What do you intend to do with the databases, etc that currently reside on the clustered instance?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1455757
Posted Thursday, May 23, 2013 3:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 6, 2013 2:54 AM
Points: 4, Visits: 21
We just want to move all the databases to one virtualized machine and not have any more clusters.
So currently the failover is disabled and we are trying to unistall the cluster. However the drop down does not show anything.
Is there any set of recommended steps before virtualizing this kind of a setup?


Thanks.
Post #1455899
Posted Thursday, May 23, 2013 3:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 6,191, Visits: 13,340
arun.zakaria (5/23/2013)
So currently the failover is disabled

How have you disabled failover?


arun.zakaria (5/23/2013)[hrand we are trying to unistall the cluster. However the drop down does not show anything.

You're running the remove node option from the sql server 2008 installer?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1455905
Posted Thursday, May 23, 2013 4:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 6, 2013 2:54 AM
Points: 4, Visits: 21
Sorry for the mistake, unfortunately there was another installation of SQL2008 on the same server, so we were trying the wrong instance.
The instance is visible now after choosing the correct installation.
Once the cluster is removed, we need to virtualize the physical SQL server.
Are there any other recommended steps to follow
after this and continue to virtualize this node?

Thanks
Post #1455941
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse