Remove SQL SERVER 2008 R2 Completely
Removing SQL Server 2008 R2 was a very hectic job for regular users and personally I faced a lot of issue doing it.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 difficulties.
It always leave some tail and sometime it even dosen’t uninstall.
But after lot of struggle I found a way to remove this piece of software.
Before telling you the step by step procedure , i want to tell you the concept behind the removal.
The things is that whenever we install SQL SERVER it install with a default 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 program list with the name
of the instance you tried during SQL server management studio login window.
More clearly — the default server is {YOUR USER ACCOUNT NAME} — > THAT’S THE DEFAULT,
BUT WHEN YOU TRY TO LOGIN WITH SOMETHING LIKE {YOUR USER ACCOUNT NAME}/SQLEXPRESS OR ANYTHING ELSE ,
sql server automatically 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.
* DON’T USE ANY SOFTWARE TO UNINSTALL SQL SERVER LIKE “TOTAL UNINSTALL” OR ANYTHING LIKE THAT”–IT WILL
CORRECT THE WHOLE INSTALLATION.AND THEN THERE WILL BE ONLY OPTION LEFT WAS FORMATTING 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 STOOPING 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 seance ).
- 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.
Related Posts
Symbian Application Development # 1
DevadminX
May 30, 2011
Symbian Rom(os) Download For Customization
DevadminX
May 2, 2011
Recent Posts
Symbian Application Development # 1
May 30, 2011
Symbian Rom(os) Download For Customization
May 2, 2011
Remove Sql Server 2008 R2 Completely
February 6, 2011