May 27, 2010 at 3:02 am
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.
May 27, 2010 at 11:54 am
which version of SQL Server are you attempting to cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2010 at 4:52 pm
It's all 2008R2 OS and SQL
May 28, 2010 at 4:12 am
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" 😉
June 10, 2010 at 6:59 pm
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.
May 22, 2013 at 5:21 am
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,
May 22, 2013 at 4:54 pm
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" 😉
May 23, 2013 at 3:06 am
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.
May 23, 2013 at 3:14 am
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" 😉
May 23, 2013 at 4:58 am
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
May 23, 2013 at 5:58 am
Rather than virtualise the existing server, just deploy and configure a new VM, retrieve your existing backups from the old server. You'll also need to script out any objects such as jobs, logins, etc.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply