This time I am going to write something completely different then my other topics.Its all about Microsoft SQL Server 2008 R2 complete uninstall.For some project I installed SQL server 2008 R2 on my Win7 x86 PC.But when i went to remove in from my Pc I face a lot of dificulties.It always leave some tail and sometime it even dosent uninstall.But after lot of struggle I found a way to remove this pice of sofware. Before telling you the step by step procudure I want to tell you the concept behind the removal.The things is that whenever we install SQL SERVER it install with a defualt instance with the name of your

user account as specified during the installation.

But the untold things is that it also create a installation entry in add-remove programe list with the name of the instance you tried during SQL server management studio login window.

More clearly -- the defualt server is {YOUR USER ACCOUNT NAME} -- > THATS THE DEFUALT,

BUT WHEN YOU TRY TO LOGIN WITH SOMETHING LIKE {YOUR USER ACCOUNT NAME}/SQLEXPRESS OR ANYTHING ELSE ,

sql server autometicaly generate a false instance of that name on your registry and also in the add-remove program list.

So, to completely remove SQL SERVER we need to perform the following step.

* DONT USE ANY SOFTWARE TO UNISTALL SQL SERVER LIKE "TOTAL UNINSTALL" OR ANYTHING LIKE THAT"--IT WILL CORREPT THE WHOLE INSTALLATION.AND THEN THERE WILL BE ONLY OPTION LEFT WAS FORMATING OS. *

1. GO TO ADD-REMOVE PROGRAM LIST --> LIST BY NAME (SO YOU COULD VIEW ALL SQL INSTALLATION ACCORDINGLY)

2. UNINSTALL ANYTHING LISTED LIKE "SQL SERVER 2008" .(QUITE SIMILAR TO INSTALL PROCESS)

3. UNINSTALL "SQL SERVER 2008 R2" FOLLOW THE STEPS.AT A POINT IT WILL LIST THE COMPONENT THAT WILL BE UNINSTALLED, CHECK THEM ALL AND CONTINUE.

4. NEXT WE NEED TO STOP THE RUNNING SQL SERVER PROCESS BY MANUALLY STOPING THEM.

5. STOP THOSE SERVICES by

navigating to the following branch using regedit.exe

HKEY_LOCAL_MACHINE SYSTEM CurrentControlSet Services

and delete the registry folder named with SQL and its instance name( use some basic sence ).

6. reboot your computer. check task manger if there is SQL server running.

7. If not, then delete the folder name SQLserver 2008 from your programs file.

 

CONGRATULATION YOU HAVE SUCCESSFULLY UNINSTALL SQL SERVER 2008 R2 FROM YOUR COMPUTER.

IF YOU FIND ANY DIFFICULTY FEEL FREE TO COMMENT ON THIS POST, I WILL TRY MY BEST TO HELP YOU OUT.