Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Instance not selectable when trying to remove node from a cluster


Instance not selectable when trying to remove node from a cluster

Author
Message
henners72
henners72
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 313
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.
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
which version of SQL Server are you attempting to cluster?

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
henners72
henners72
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 313
It's all 2008R2 OS and SQL
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
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" ;-)
henners72
henners72
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 313
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.
arun.zakaria
arun.zakaria
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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,
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
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" ;-)
arun.zakaria
arun.zakaria
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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.
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
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" ;-)
arun.zakaria
arun.zakaria
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search