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 (AT) discussions (DOT) microsoft.com> wrote

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:

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 (AT) discussions (DOT) microsoft.com> wrote

Hiten,
can you please let me know any reg keys need to be deleted before rebooting?

"Geoff N. Hiten" wrote:

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 (AT) discussions (DOT) microsoft.com> wrote

Thanks much..

Do i need to delete resources from cluster admin?

If yes, is it from resorces or from groups?


"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 (AT) discussions (DOT) microsoft.com> wrote