Uninstall Cluster Service with SQL Server

[dougcoulter]

Hello everyone - I ran into a problem today deploying my high availability cluster from my office environment to our customer's production environment. It resulted in me uninstalling the cluster service on both of my cluster nodes, and then reinstalling. After reinstall, the cluster service behaved properly, but it was no longer managing my SQL Server instance (not surprisingly, I guess). So I tried to uninstall the SQL Server instance using the SQL Server CD, to no avail. I then tried to install a new virtual instance, which failed.

I am not sure what options I have at this point. My original virtual SQL Server instance still exists - is it possible to manually create the necessary resources in the cluster for it? If not, what options do I have to successfully uninstall SQL Server?

Thanks...

 

[dougcoulter]

I wound up reinstalling the OS for each node and going through the process of setting up the cluster service and then SQL Server. All seems to be ok now.

One question I still have is what sequence of operations should I follow if in fact I ever do have to uninstall/reinstall the cluster service? Should I uninstall the Virtual SQL Server first?

Thanks again...

 

[victorv]

last week I have encountred a similar problem and I have
followed the steps

- install OS
- install cluster
- Install SQL server enterprise edition.

All was going well bu the day after the customer asked me to reinstall SQl :
someting was no good (authentication mode, regional setting, ecc)

then I have Unistalled SQL (using CD) and I have reinstalled
it whith new directives, but I have encountred a non
specificated error during SQL reinstallation. Also
rebooting or doing other typical IT operations, as switching
off lights, use left hand instead the right ..., the result
was the same.

Fortunately, the system was not still in production and
I have unconfigured cluster and reinstalled it and
reinstalled SQL : all went well.

Then I belive the sequence is


Install OS
Install Cluster
Install SQL
Unistall SQL
Reinstall SQL

for some strange cause I have had to do :

Install OS
Install Cluster
Install SQL
Unistall SQL
UNINSTALL CLuster
REINSTALL CLuster
Reinstall SQL

bye

 

[GiaBetiu]

Yes, indeed,...
the sequence is:
1. evict one node
2. uninstall cluster on that node
3. after restart the clustered sql instance will be gone, and a new instance will be created
4. uninstall SQL (however, you can consider uninstall before the cluster service too,, but after evict will not function anyway)
5. on node2: uninstall SQL
6. uninstal cluster

then:
7. reinstal cluster, create cluster (join), install sql

Gia Betiu
gia@almondeyes.net
Computer Eng. CNE 4, CNE 5, MCSE Win2K
new:

http://www.almondeyes.net

(just started)