dbTalk Databases Forums  

How to remove (uninstall ) cluster sql server manually

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss How to remove (uninstall ) cluster sql server manually in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Suchi
 
Posts: n/a

Default How to remove (uninstall ) cluster sql server manually - 12-28-2007 , 06:56 PM






HI All,


As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of reboots of
the both the nodes.

I am still getting Getting "Cannot delet MSsqlserver: Error while deleting
key" error.

I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to get
deleted?

Thanks in advance
Suchi





Reply With Quote
  #2  
Old   
Suchi
 
Posts: n/a

Default RE: How to remove (uninstall ) cluster sql server manually - 12-28-2007 , 07:16 PM






To be clear enough, In below Kb article it is mentioned as

If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.

I am new to Clusters, what are all the resourcs do i need to delete?

How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us




"Suchi" wrote:

Quote:
HI All,


As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of reboots of
the both the nodes.

I am still getting Getting "Cannot delet MSsqlserver: Error while deleting
key" error.

I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to get
deleted?

Thanks in advance
Suchi





Reply With Quote
  #3  
Old   
Tom Moreau
 
Posts: n/a

Default Re: How to remove (uninstall ) cluster sql server manually - 12-29-2007 , 06:30 AM



You'll need to go into ClusterAdmin and remove the resources. Don't remove
the disk resource.

Also, check out www.clusterhelp.com for suitable training in clusters.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Suchi" <Suchi (AT) discussions (DOT) microsoft.com> wrote

To be clear enough, In below Kb article it is mentioned as

If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.

I am new to Clusters, what are all the resourcs do i need to delete?

How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us




"Suchi" wrote:

Quote:
HI All,


As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of reboots
of
the both the nodes.

I am still getting Getting "Cannot delet MSsqlserver: Error while
deleting
key" error.

I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to get
deleted?

Thanks in advance
Suchi






Reply With Quote
  #4  
Old   
Suchi
 
Posts: n/a

Default Re: How to remove (uninstall ) cluster sql server manually - 12-29-2007 , 08:33 AM



Thanks Much tom..
Do i need to delete sql group also to clean the sql server?


"Tom Moreau" wrote:

Quote:
You'll need to go into ClusterAdmin and remove the resources. Don't remove
the disk resource.

Also, check out www.clusterhelp.com for suitable training in clusters.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Suchi" <Suchi (AT) discussions (DOT) microsoft.com> wrote in message
newsDE03400-B723-4800-BD98-B0891596660A (AT) microsoft (DOT) com...
To be clear enough, In below Kb article it is mentioned as

If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.

I am new to Clusters, what are all the resourcs do i need to delete?

How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us




"Suchi" wrote:

HI All,


As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of reboots
of
the both the nodes.

I am still getting Getting "Cannot delet MSsqlserver: Error while
deleting
key" error.

I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to get
deleted?

Thanks in advance
Suchi







Reply With Quote
  #5  
Old   
Tom Moreau
 
Posts: n/a

Default Re: How to remove (uninstall ) cluster sql server manually - 12-29-2007 , 10:54 AM



No, just keep the group and the disk resource. Remove everything else
within the SQL group. You'll probably want to reboot afterwards (both
nodes).

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Suchi" <Suchi (AT) discussions (DOT) microsoft.com> wrote

Thanks Much tom..
Do i need to delete sql group also to clean the sql server?


"Tom Moreau" wrote:

Quote:
You'll need to go into ClusterAdmin and remove the resources. Don't remove
the disk resource.

Also, check out www.clusterhelp.com for suitable training in clusters.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Suchi" <Suchi (AT) discussions (DOT) microsoft.com> wrote in message
newsDE03400-B723-4800-BD98-B0891596660A (AT) microsoft (DOT) com...
To be clear enough, In below Kb article it is mentioned as

If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.

I am new to Clusters, what are all the resourcs do i need to delete?

How to manually remove SQL Server 2000 default, named, or virtual
instance
http://support.microsoft.com/kb/290991/en-us




"Suchi" wrote:

HI All,


As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of
reboots
of
the both the nodes.

I am still getting Getting "Cannot delet MSsqlserver: Error while
deleting
key" error.

I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to
get
deleted?

Thanks in advance
Suchi








Reply With Quote
  #6  
Old   
Suchi
 
Posts: n/a

Default Re: How to remove (uninstall ) cluster sql server manually - 12-30-2007 , 01:56 PM



Thanks much Tom.
I have deleted cluster resources (except disk)as you said.
I could delete all except hklm\software\microsoft\mssqlserver on node1.
Node2 is completed cleaned. Eeven deleted
hklm\software\microsoft\mssqlserver from node2.

Still getting cannt delete key while deleting above reg key on node1.
Is there anythng I am missing here?Done several reboots also..

Thanks a lot..


"Tom Moreau" wrote:

Quote:
No, just keep the group and the disk resource. Remove everything else
within the SQL group. You'll probably want to reboot afterwards (both
nodes).

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Suchi" <Suchi (AT) discussions (DOT) microsoft.com> wrote in message
news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0 (AT) microsoft (DOT) com...
Thanks Much tom..
Do i need to delete sql group also to clean the sql server?


"Tom Moreau" wrote:

You'll need to go into ClusterAdmin and remove the resources. Don't remove
the disk resource.

Also, check out www.clusterhelp.com for suitable training in clusters.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Suchi" <Suchi (AT) discussions (DOT) microsoft.com> wrote in message
newsDE03400-B723-4800-BD98-B0891596660A (AT) microsoft (DOT) com...
To be clear enough, In below Kb article it is mentioned as

If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.

I am new to Clusters, what are all the resourcs do i need to delete?

How to manually remove SQL Server 2000 default, named, or virtual
instance
http://support.microsoft.com/kb/290991/en-us




"Suchi" wrote:

HI All,


As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of
reboots
of
the both the nodes.

I am still getting Getting "Cannot delet MSsqlserver: Error while
deleting
key" error.

I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to
get
deleted?

Thanks in advance
Suchi









Reply With Quote
  #7  
Old   
Tom Moreau
 
Posts: n/a

Default Re: How to remove (uninstall ) cluster sql server manually - 12-30-2007 , 02:07 PM



Hmm. Have you removed all of the binaries, e.g. C:\Program Files\Microsoft
SQL Server\...

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Suchi" <Suchi (AT) discussions (DOT) microsoft.com> wrote

Thanks much Tom.
I have deleted cluster resources (except disk)as you said.
I could delete all except hklm\software\microsoft\mssqlserver on node1.
Node2 is completed cleaned. Eeven deleted
hklm\software\microsoft\mssqlserver from node2.

Still getting cannt delete key while deleting above reg key on node1.
Is there anythng I am missing here?Done several reboots also..

Thanks a lot..


"Tom Moreau" wrote:

Quote:
No, just keep the group and the disk resource. Remove everything else
within the SQL group. You'll probably want to reboot afterwards (both
nodes).

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Suchi" <Suchi (AT) discussions (DOT) microsoft.com> wrote in message
news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0 (AT) microsoft (DOT) com...
Thanks Much tom..
Do i need to delete sql group also to clean the sql server?


"Tom Moreau" wrote:

You'll need to go into ClusterAdmin and remove the resources. Don't
remove
the disk resource.

Also, check out www.clusterhelp.com for suitable training in clusters.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Suchi" <Suchi (AT) discussions (DOT) microsoft.com> wrote in message
newsDE03400-B723-4800-BD98-B0891596660A (AT) microsoft (DOT) com...
To be clear enough, In below Kb article it is mentioned as

If the instance of SQL Server you are removing was clustered, remove
any
cluster resources for the instance that may remain in the Cluster
Administrator.

I am new to Clusters, what are all the resourcs do i need to delete?

How to manually remove SQL Server 2000 default, named, or virtual
instance
http://support.microsoft.com/kb/290991/en-us




"Suchi" wrote:

HI All,


As HIten said,(in my previous post) I am able to remove all the
registry
entries except hklm\software\microsoft\mssqlserver after couple of
reboots
of
the both the nodes.

I am still getting Getting "Cannot delet MSsqlserver: Error while
deleting
key" error.

I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to
get
deleted?

Thanks in advance
Suchi










Reply With Quote
  #8  
Old   
Suchi
 
Posts: n/a

Default RE: How to remove (uninstall ) cluster sql server manually - 12-30-2007 , 07:17 PM



Yes Tom. I deleted all binaries.

"Suchi" wrote:

Quote:
To be clear enough, In below Kb article it is mentioned as

If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.

I am new to Clusters, what are all the resourcs do i need to delete?

How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us




"Suchi" wrote:

HI All,


As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of reboots of
the both the nodes.

I am still getting Getting "Cannot delet MSsqlserver: Error while deleting
key" error.

I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to get
deleted?

Thanks in advance
Suchi





Reply With Quote
  #9  
Old   
Tom Moreau
 
Posts: n/a

Default Re: How to remove (uninstall ) cluster sql server manually - 12-30-2007 , 10:17 PM



And the appropriate keys were removed from CurrentControlSet\Services etc.?
If so, then you may very well have to rebuild the node.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Suchi" <Suchi (AT) discussions (DOT) microsoft.com> wrote

Yes Tom. I deleted all binaries.

"Suchi" wrote:

Quote:
To be clear enough, In below Kb article it is mentioned as

If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.

I am new to Clusters, what are all the resourcs do i need to delete?

How to manually remove SQL Server 2000 default, named, or virtual
instance
http://support.microsoft.com/kb/290991/en-us




"Suchi" wrote:

HI All,


As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of
reboots of
the both the nodes.

I am still getting Getting "Cannot delet MSsqlserver: Error while
deleting
key" error.

I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to
get
deleted?

Thanks in advance
Suchi






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.