How to remove (uninstall ) cluster sql server manually?

Hi All,
Environment:windows2003 sp1
SQl server 2000, sp2, and It is clustered(2 nodes)
I need to uninstall SQL server2000 . When i tried to uninstall from setup,
i have got error and so i have deleted manually so sql binaries and registry
key(services\mssqlserver and sqlagent).
Now i am not able to uninstall completely..
Can anyone help me what are the registry keys, files etc need to be deleted
for this unstallation to complete?How to clean it properly?
Thanks in adavnce
Suchi
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:CC2377D2-7128-4C59-AF25-29136F9AB016@.microsoft.com...
> Hi All,
> Environment:windows2003 sp1
> SQl server 2000, sp2, and It is clustered(2 nodes)
> I need to uninstall SQL server2000 . When i tried to uninstall from
> setup,
> i have got error and so i have deleted manually so sql binaries and
> registry
> key(services\mssqlserver and sqlagent).
> Now i am not able to uninstall completely..
> Can anyone help me what are the registry keys, files etc need to be
> deleted
> for this unstallation to complete?How to clean it properly?
> Thanks in adavnce
> Suchi
|||Thanks Hiten for the quick reponse.
I have gone through the below Link before uninstalling .
As i was getting error while uninstalling from setup(method 2),I removed the
data and some of binaries . I cloud not delete the reg key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer.
Getting "Cannot delet MSsqlserver: Error while deleting key" error.
SQL server is clustered.Even i could not delet some binaries. Getting access
denied error. I am using admin account with full permissions..
Thanks..
Suchi
"Geoff N. Hiten" wrote:

> How to manually remove SQL Server 2000 default, named, or virtual instance
> http://support.microsoft.com/kb/290991/en-us
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:CC2377D2-7128-4C59-AF25-29136F9AB016@.microsoft.com...
>
|||You may have to reboot nodes to clear some leftover file locks.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:2CBE9799-2529-40D0-B4F3-621629258E63@.microsoft.com...[vbcol=seagreen]
> Thanks Hiten for the quick reponse.
> I have gone through the below Link before uninstalling .
> As i was getting error while uninstalling from setup(method 2),I removed
> the
> data and some of binaries . I cloud not delete the reg key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer.
> Getting "Cannot delet MSsqlserver: Error while deleting key" error.
> SQL server is clustered.Even i could not delet some binaries. Getting
> access
> denied error. I am using admin account with full permissions..
> Thanks..
> Suchi
> "Geoff N. Hiten" wrote:
|||Hiten,
can you please let me know any reg keys need to be deleted before rebooting?
"Geoff N. Hiten" wrote:

> You may have to reboot nodes to clear some leftover file locks.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:2CBE9799-2529-40D0-B4F3-621629258E63@.microsoft.com...
>
|||It sounds like you may have some SQL services still running. That will lock
down certain file folders and possibly registry keys. Stop all the SQL
services and follow the instructions that match your setup (named or default
instance) exactly on all nodes. If something prevents a folder or reg key
deletion, then it is time to reboot, verify the services are not running,
and try again.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:07AC7A23-0505-473D-BC3D-FFB13321AC07@.microsoft.com...[vbcol=seagreen]
> Hiten,
> can you please let me know any reg keys need to be deleted before
> rebooting?
> "Geoff N. Hiten" wrote:
|||You my need to remove some virtual resources if the processes outlined in
the KB article do not clear them out. Basically, try and get the cluster
back to where it was before the blown SQL install.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:CEF3C105-C5F4-4B53-926A-B4D90C8CD53F@.microsoft.com...[vbcol=seagreen]
> Thanks much..
> Do i need to delete resources from cluster admin?
> If yes, is it from resorces or from groups?
>
> "Geoff N. Hiten" wrote:

How to remove (uninstall ) cluster sql server manually

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
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
>
>
|||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@.discussions.microsoft.com> wrote in message
news:DDE03400-B723-4800-BD98-B0891596660A@.microsoft.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
>
>
|||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@.discussions.microsoft.com> wrote in message
> news:DDE03400-B723-4800-BD98-B0891596660A@.microsoft.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:
>
>
|||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@.discussions.microsoft.com> wrote in message
news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0@.microsoft.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@.discussions.microsoft.com> wrote in message
> news:DDE03400-B723-4800-BD98-B0891596660A@.microsoft.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:
>
>
|||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:

> 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@.discussions.microsoft.com> wrote in message
> news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0@.microsoft.com...
> Thanks Much tom..
> Do i need to delete sql group also to clean the sql server?
>
> "Tom Moreau" wrote:
>
>
|||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@.discussions.microsoft.com> wrote in message
news:4F2A3078-2465-421E-BF4C-8D86978E442E@.microsoft.com...
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:

> 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@.discussions.microsoft.com> wrote in message
> news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0@.microsoft.com...
> Thanks Much tom..
> Do i need to delete sql group also to clean the sql server?
>
> "Tom Moreau" wrote:
>
>
|||Yes Tom. I deleted all binaries.
"Suchi" wrote:
[vbcol=seagreen]
> 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:
|||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@.discussions.microsoft.com> wrote in message
news:9D35C0B0-7488-4747-B56B-E787062E5C39@.microsoft.com...
Yes Tom. I deleted all binaries.
"Suchi" wrote:
[vbcol=seagreen]
> 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:

How to recover the primary sevrer in a cluster?

Hello, everyone:
The two SQL Server 2k (SP4) are running on W2K(SP4) in clustered A/A mode. The seconary server took over successfuly as the primary server crached. How to recover the primary sevrer?
Thanks a lot.Few articles to help:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx and http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part4/c1261.mspx

HTH

how to query the SQL server name?

I use :

select @.@.servername to find SQL server name. But it will return the virtual OS name in cluster environment, not SQL server name. I need this server name for error handling as well as generating query scripts.

How to query SQL server name?

You can:

-Query the name through xp_cmdshell, reading it from the SET command
-Creating your own CLR function to read environment variables
-Read the registry for the needed value through xp_regread /buit be careful this is undocumented and might be deprecated in further versions)

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

If you are using SQL Server 2005, then you can use the SERVERPROPERTY built-in to get the various names.

select SERVERPROPERTY('MachineName') as [Cluster Virtual Server Name]

, SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as [Cluster Node Name]

Otherwise, you will have to get the netbios name using any of the OS utilities.

|||

1. Suppose I have serveral instance on a cluster, how do I figure out my current connecting virtual sql server name by querying in CMD, or regitry? I do not see how.

2. Wrote CLR will incur higher cost (time to create and install, and maitenance). The cost out weights benefit. I donot want to do.

3. xp_cmdshell is disabled due to our security concern on production system. We do not have plan to use it.

|||I did the query but the SERVERPROPERTY('MachineName') returns OS virtual name not SQL virtual name. I had looked into other serverproperty parameter, none of them will return current SQL virtual server name.