Problem:-
One of my friend was installing cluster SQL Server, installation was stopped in the middle of something and he was not able to remove the SQL Server from add/remove programs or SQL Server setup. He has deleted the registry, folder manually but still he can see the SQL Server Services in Services.msc. He called me for the issue, I have provided him the below solution and it will work.
Solution:
1) Go to command prompt and use SC command to delete service
sc delete sqlserveragent
sc delete mssqlserver
2) You have to also delete the services registry entry using regedit
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services
Advertisements
THANK YOU!!
Thanks ………
I read your blog on how to Clear/Remove SQL Server Services from Services.msc. I completed the sc commands but am unsure how to proceed from there. I found the location in regedit but cannot find an msqlserver anything. What should I look for or should I delete the entire services folder?
I appreciate any help you can provide. I am trying to delete msde from my machine and it will not do it from control panel or uninstall on programs menu.
try to find out the sql server in find string, it will take you to the right registry path.
I have found the path but there are several items in the path. Am I to delete them all?
yes
Hello Jug
Thanks for the above qurey
but
How remove the name instances
I have given the sc delete SQL Server (P001) and multiple way i tried but i can’t, So could you please clear on this.
as i have unistalled SQL 2000 version with out removing the HotFixes from the server after i try to remove but i am getting error like supporting files missed.
if we have two instances running in the same server, how we can specifically remove one instance through this method????
in the second delete option do I delete everything from the HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services ?