.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Need complete, detailed instructions on how to remove/uninstall SQL Server 2008 and R2

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server

There are thousands of forum posts related to uninstalling SQL Server that provide varied information.  Most refer to the BOL article http://msdn.microsoft.com/en-us/library/ms143412.aspx, which is useless in most error situations.  Can anyone provide true, complete instructions for removing all SQL Server components from a machine?  I'm not sure why there isn't a robust MS-provided utility for this, but I'll be relieved just to have a manual method.  I understand that there will be registry hacks, security group mods, folder deletions/renames from god knows how many places, and probably a cauldron of frog legs and shaken babies.  Just please don't make me cruise these endless seas of bogus forum posts any longer.  I am thirsty and seasick.

Thank you,


PS My Environment:

Windows 7 Ultimate 64 bit

SQL Server 2008 R2 (I think some of my old SQL 2008 "plain" install may still reside as well) Developer Edition - All components

Yes, I have VS 2010, which prbly caused the SQLExpress BS to hork my origh install in the first place.  I yearn for the day when VS and SQL teams kiss and make up.

View Complete Post

More Related Resource Links

SQL Server 2008 Uninstall

I am running SQL Server 2008 on VISTA. I am having problems with SSIS components tha need to run in 32-bit.  It was recommended to unistall 2008 and re-install 2005.  However, trying to uninstall 2008 is causing my machine to freeze half-way through the process.  Before I tried to unistall I tried to repair and it also caused my screen to freeze (I issued a hard-shut down of my machine).  Now I am not sure what is happending.  How can I fix this?

How I can remove The Microsoft SQL Server 2008 Express installation manually.

How I can remove The Microsoft SQL Server 2008 Express installation manually ?   Other components uninstalled via Add/Remove but i cant remove SQL Server 2008 Express     From Add/Remove the following is installed:Microsoft SQL Server 2008   I have attempted to uninstall it via the Add/Remove method and this also failed.

Uninstall SQL Server 2008 trial version

I would like to know how to properly uninstall SQL Server 2008 trial version altogether.

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2 (Express)

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2?  The regular remove program does not have this option highlighted.    I am trying use some of the advance option and learn something more and now ssms is useless.         the discovery report tells me these are installed but I have no way of uninstalling.  .  I want to replace this with my developer edition that I purchased but have lots of trouble installing because of the express version.  Please help.  I'd really appreciate it. " Sql Server 2008     Management Tools - Basic 1033 Express Edition 10.50.1092.20 No Sql Server 2008     Client Tools Connectivity 1033 Express Edition 10.1.2531.0 No Sql Server 2008     Client Tools Backwards Compatibility 1033 Express Edition 10.1.2531.0 No Sql Server 2008     Client Tools SDK 1033 Express Edition 10.1.2531.0 No "

SQL Server 2008 uninstall fails

While trying to remove SQL Server 2008 Express I get a message saying "SQL Server 2008 Setup has stopped working" Following is the log for the failure: Overall summary:   Final result:                  Failed: see details below   Exit code (Decimal):           -2068643839   Exit facility code:            1203   Exit error code:               1   Exit message:                  Failed: see details below   Start time:                    2010-09-11 15:03:47   End time:                      2010-09-11 15:05:23   Requested action:              Uninstall   Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100911_150303\sql_common_core_Cpu32_1.log   Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0   Machine Properties:  &nb

SQL Server 2008 Installation / Uninstall failed: Error 1603

Hello! I've been trying to install the SQL Server 2008 CTP 5.0 on a Windows Server 2008. The installation failed and left the shared components installed but the database engine was missing. So I tried to roll back the installation and stumbled upon the problem again. Now I can't install or uninstall any SQL Server (I tried 2005 as well) without these results. This is the file *Sql_Cpu32_1_ComponentUpdateSetup.log === Verbose logging started: 01.01.2001  20:30:03  Build type: SHIP UNICODE 4.00.6001.00  Calling process: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\setup100.exe ===MSI (c) (30:CC) [20:30:03:671]: Resetting cached policy valuesMSI (c) (30:CC) [20:30:03:671]: Machine policy value 'Debug' is 0MSI (c) (30:CC) [20:30:03:671]: ******* RunEngine:           ******* Product: {8151C56C-5426-481C-96AF-F221FE1A10F2}           ******* Action:            ******* CommandLine: **********MSI (c) (30:CC) [20:30:03:687]: Client-side and UI is none or basic: Running entire install on the server.MSI (c) (30:CC) [20:30:03:687]: Grabbed execution mutex.MSI (c) (30:CC) [20:30:04:062]: Cloaking enabled.MSI (c) (30:CC) [20:30:04:062]: Attempting to enable all disabled privileges before calling Install on ServerMSI (c) (30:CC) [20:30:04:125]: Incrementing counter to disable shutdown. Counter after increment: 0MSI (s) (DC:28) [20:30:04:218]: Grabbed execution mutex.MSI (s) (

Can't remove SQL Server Enterprise 2008 R2

I accidentally installed the enterprise version of SQL. I'm trying to remove it but it keeps erroring out with 1618 errors and I'm not sure. Here are the parts of the log with the failures.   Detailed results:   Feature:                       Database Engine Services   Status:                        Failed: see logs for details   MSI status:                    Failed: see details below   MSI error code:                0x1618   MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100914_160715\sql_fulltext_Cpu64_1.log   MSI error description:           MSI status:                    Failed: see details below   MSI error code:                0x1618   MSI

Cannot uninstall SQL Server 2008 R2 Developer from Vista 32 bit SP2

Hi, I installed SQL Server 2008 R2 Developer and I now wish to go back to an earlier configuration (2008) but I cannot uninstall it. I do have Visual Studio 2008 and 2010 installed (with their instance of SQLEXPRESS), is this blocking the total removal of SQL Server 2008 or is their another issue here? The uninstall reports that all worked fine. Thanks for your help, Bex

OK to uninstall microsoft sql server 2008 r2 upgrade advisor?

After upgrading to microsoft sql server 2008 r2, is it OK to uninstall microsoft sql server 2008 r2 upgrade advisor and microsoft  sql server 2008 r2 setup support files?

How to uninstall properly SQL Server 2008 ?


Hello !

I want to uninstall properly SQL Server 2008 with a command line

Is there a good documentation on how to uninstall it without forget things (before / after) ?

There are a lot of remaining folder, components, registry key .....

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

Remove SQL Server 2008 R2 Express Edition from Windows 7 professional


Are there any good practices to follow in order to remove/uninstall SQL Server 2008 R2 Express Edition from Windows 7 professional laptop? Thanks for your comments.




Microsoft SQL Server 2005 Uninstall remove problem


In trying to install the 2010 Switched On Schoolhouse Home Edition it tries to install the SQL server then comes up with error message that it fails.


Tech support walked me through trying to delete all the SQL titles manually and I came to the last and only application of Microsoft SQL Server 2005 with a log file "80" that will NOT delete.


The IT told me it was corrupt in the registry.


Is there ANY way to delete this??? The new installation has a newer version but I think it is the same one.


Thanks, Ricky

SQL Server 2008 Development problems with Visual Studio 2010 Ultimate uninstall and VS2010 premium i


I installed VS2010 Ultimate to test it out but had license for the VS2010 premium only.  After uninstalling ultimate and reinstalling VS2010 premium, my SQL Server 2008 now refuses to connect to my databases stating: 

TITLE: Connect to Server

Cannot connect to Q9300\SQL200801.


Trying to uninstall or repair sql server express 2008 - I get the following error: The Given key was


Trying to uninstall or repair sql server express 2008 - I get the following error: The Given key was not present in the dictionary.  i have tried many things, reinstalling, etc, but nothing works.  i have a working version of 2008 express R2, but i want to remove the 2008 express.  any help would be appreciated.  i have pasted the contents of one of the logs below.

Overall summary
  Final result:                  Failed: see details below
  Exit code (Decimal):           -71883602
  Exit facility code:            951
  Exit error code:               9390
  Exit message:                  The given key was not present in the dictionary.
  Start time:                    2011-04-05 23:04:06
  End time:                      2011-04-05 23:04:20

SQL Server 2008 - unable to uninstall completely



I decided to reinstall my SQL server 2008 Express edition on windows 7 professional. I did went to control panel -> add or remove program and uninstalled all SQL server applications that i saw.

However in start  -> program  -> microsoft SQL sever 2008 am able to see all all the applications. Now am not able to uninstall it completely neither reinstall a new SQL server. 

Please help.



Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend