THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
 in Aaron Bertrand (Entire Site) Search

## Aaron Bertrand

Aaron is a Product Evangelist for SentryOne, makers of Plan Explorer and a performance monitoring and event management platform for the Microsoft Data Platform and VMware. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features, and also blogs at blogs.sentryone.com and SQLPerformance.com; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at major conferences, user group meetings, and SQL Saturday events worldwide.

# Fun with software : uninstalling SQL Server 2008 R2 Evaluation Edition

Update 2012-07-23  :  Note that much of these instructions also work for SQL Server 2012 Evaluation Edition, many of which will start expiring soon...

Here we go 'round the uninstall bush...

Today I spun up a rather aging VM so that I could take some screen shots from the 2008 R2 version of Management Studio.

When I clicked on my shortcut, I received this error:

For searchability, here is the text (with an actual clickable link, imagine that):

Of course what this meant was that, for this particular VM, I had installed an Enterprise Evaluation instance before the RTM bits for Developer Edition were available.  And clearly this happened more than 180 days ago, and I forgot about it.

If you go the link (which ends up at http://www.microsoft.com/sqlserver/en/us/default.aspx), there isn't really any information about converting evaluation software to licensed software (even if I already have licensed bits in hand).  In fact there is not really any information about Evaluation Edition at all, except for an offer to install a second trial instance on my machine.  I'm trying to remove one, but thanks anyway.

So the first thing I do is to install a real, licensed version of SQL Server 2008 R2 Developer Edition.  I figure, if anything, it will at least give me a functional Management Studio again, even if I have an outdated Evaluation Edition engine lying around.  Nope, I run through install, and when I try to launch Management Studio, my evaluation period has still expired.  I plead to #sqlhelp on twitter, and I'm told I need to remove all of the 2008 R2 bits.  This was the first time I'd had any reason to uninstall 2008 R2; at my previous job, we had only just migrated to 2008 in production late last year.  I guess I should test cleanup more often.

Now, removing SQL Server 2008 R2 turns out to be a much bigger challenge than you might expect.  Sure, you can go through the Control Panel and uninstall all of the components individually, but this is a hassle, and it still might not work very smoothly.  To clear a path, I've been uninstalling applications that might be related (e.g. Visual Studio), and even applications with no hope in hell of being related: Office 2010, Flash, Windows Live "Essentials"... I even uninstalled an instance of SQL Server 2008 (not an eval), and when I tried to remove the setup support files, I received this warning:

Why on earth are the R2 Common Files dependent on SQL Server 2008 Setup Support Files?  And further to that, I'd like to know why, when I clicked No on this dialog, it seemed to remove the SQL Server 2008 Setup Support Files anyway.  It turns out there is some flag that removes the entry from the Programs and Features list, even if you don't go through with the uninstall.  All was returned to normal when I closed the window and opened it again.

Anyway, let's see what happens when I try to remove R2 via the Control Panel.  I right-click the item in the list (and as you can see, "the list" is pretty short - and never mind the blurred out entries, I'll talk more about those soon, and they aren't related to R2):

When I choose Uninstall/Change, I get this box, and I click Remove of course:

When I click Remove, I get the Setup Support Rules dialog (just like I do for a new installation), and then when I click OK, I get this lovely dialog (I trimmed it so I wouldn't have to shrink it, but you get the gist):

Why does this not seem like it will end well?

Because according to the dialog, nothing is going to be removed (usually you see actual features with checkboxes).  I should not even be able to see a Next > button.  But for fun, I'll click it anyway, since my only other option at this point is to Cancel.  I click Next > a couple of times, then a big shiny Remove button, and then after several seconds I get another even more lovely dialog, indicating that the uninstall has crashed:

And again for searchability (typo and all):

 TITLE: SQL Server Setup failure.------------------------------SQL Server Setup has encountered the following error:No feature were uninstalled during the setup execution. The requested features may not be installed. Please review the summary.txt logs for further details.Error code 0x84B30002.------------------------------OK------------------------------

At this point I've spent more time on this than I would have if I had just built a brand new VM and started over.  But I was determined to see it through.  So I finally gave in and decided to go the msiexec.exe /x route.  I located all of the R2-related GUIDs in the following registry key:

 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\

Here is one example:

So I went through the entire list, and saved the following commands to a batch file:

 rem DisplayNamemsiexec /x "{guid}"

And I also added one that wasn't in the GUID list; there was a key under Uninstall called "Microsoft SQL Server 2008 R2" with the following properties:

Here is what my final .bat file looked like. You'll note that I put the Setup Support Files last.  Also please note that your set of GUIDs may be different than mine... I'm just listing what I did as an example:

 rem SQL Server 2008 R2 Common Filesmsiexec /x "{234F6B0D-10AE-4BB7-B2F3-E48D4861952D}"rem SQL Server 2008 R2 Common Filesmsiexec /x "{36F70DEE-1EBF-4707-AFA2-E035EEAEBAA1}"rem SQL Server 2008 R2 Database Engine Sharedmsiexec /x "{A2122A9C-A699-4365-ADF8-68FEAC125D61}"rem Microsoft SQL Server 2008 Setup Support Files msiexec /x "{C0C690C8-F335-4BA4-A2AD-675EAD1DFA90}"rem SQL Server 2008 R2 Database Engine Sharedmsiexec /x "{C942A025-A840-4BF2-8987-849C0DD44574}"rem Microsoft SQL Server 2008 R2 (64-bit)msiexec /x "{20E42995-BBE9-4697-8394-FCDC4338706B}"rem Microsoft SQL Server 2008 R2 Setup (English)msiexec /x "{C3E48238-5FA0-4C82-9509-36D47E371A29}"

Running through these, I had several that returned a dialog about an unexpected error, but I ignored those and plowed through.  When I was finished, I ran the batch file again, and every line item raised this dialog:

This is a good thing; it smells like I'm almost home.  So - finally - I try to run SQL Server 2008 R2 setup again.  To avoid some wasted time, I install only the Management Tools on my first run.  Though, if I'm being honest, even installing just the client tools takes several minutes.  Precious, Monday Night Football minutes.

And, believe it or not, we have success.

That was WAY too painful, and I'll never get that time back. Hopefully this post will prevent you from going down a similar rathole.  My advice:

1. Build VMs with the expectation that they may need to be paved over and rebuilt from scratch.  Keep SQL Server installation files, service packs, hotfixes, and slipstreamed sources handy on a non-virtualized machine or on removable storage.

2. Try everything in your power to avoid Evaluation Edition. Spend the $49 on Developer, and stop watching the clock or coming up with schemes to set your clock back to the 1980s. Developer is not free like the eval, but it will be easier to migrate / replace than an expired evaluation. I would have gladly spent$49 to not go through what I just documented here.

3. When someone tells you to pave over your VM because R2 "does not uninstall nicely," listen to them.  I have two VMs that were in this state at the beginning of the day.  I'll let you guess how I'm going to deal with the second one.

4. Because it bears repeating: avoid Evaluation Edition if there is any chance at all the software will be expected to outlast the 180-day trial period.  If you can't avoid it, when you're done evaluating, perform a thorough cleansing of your machine.  You never know how old software can learn new, frustrating tricks.

Published Monday, October 25, 2010 9:12 PM by AaronBertrand

#### AlexK said:

Yeah.

Recently I was helping someone who bought a netbook with preinstalled trial McAfee, which expired. The only thing that worked was to nuke and pave.

October 25, 2010 11:19 PM

#### Patrick Flynn said:

This wonderful feature works even when eval edition is upgraded before expiry.

Scenario was: Installed veal edition to test functionality. after 90 days uninstalled eval and installed the licensed standard edition. After another 90 days the database engine kept going but SSMS, SQL Agent and other components ceased functioning as they had "expired".

October 26, 2010 7:14 AM

Oh dear oh dear. Thanks for highlighting this mess.

October 27, 2010 11:22 AM

#### Jason Coombes said:

Just hit this one today as I had originally installed the tools from SQL 2008 Enterprise Evaluation but later upgraded to SQL 2008 R2 Developer Edition (engine and tools). Luckily the solution was quite straight forward after following Option 2 in this KB article:

http://support.microsoft.com/kb/971268

Re-ran the edition upgrade for R2 and selected to only upgrade shared tools (SSMS, etc) and now I'm back and running again.

November 18, 2010 5:59 AM

#### Larry Watson said:

Thank god

November 30, 2010 9:04 PM

#### Dave said:

Thanks a lot.  What a nightmare.

December 6, 2010 11:01 PM

#### Mark said:

Thanks so much for this info.  I am in the bat file stage but things look promising.  Like Dave said, what a nightmare.  On the plus side I did learn quite a bit.

December 28, 2010 4:35 PM

#### Laurie said:

Thank you for sharing! It was wuch a nightmare!

January 4, 2011 3:36 PM

#### Victor M Sanchez (Atharky) said:

OMG! i come later to this post! this issue was raises by the uninstallation of Denali for me... painfull and long work to resolve.

I go to publish this issue in spanish in my blog if you don't have any problem.

January 25, 2011 10:12 AM

#### AaronBertrand said:

Hi Victor, of course I have no issue with you posting a translation to your blog.

Cheers,

Aaron

January 25, 2011 11:05 AM

#### Junior said:

Thanks a lot,

I also tried with Windows Installer Cleanup Utility which didn't help (the tool is retired anyway, but it helped a lot before)

January 31, 2011 2:43 AM

#### Bairo said:

veramente un grande aiuto. Thank you.

February 3, 2011 3:21 AM

Thank you....10 hours fighting with the server. We won though!

If you can call it a win...

But yeah SQL is installed with no errors.

Had to do some CCleaner work though (since they retired Windows Installer Cleanup Utility...omg M$admitting they did something wrong?!), and the WMI component seemed to be busted, had to rebuilt the repository. haha did you read this one though? http://support.microsoft.com/kb/971268 so funny...if i could uninstall it the right way you think I wouldnt M$? made me lol. just like the instructions on a peanut bag :" Open bag, eat".

Thanks man :)

February 10, 2011 10:53 AM

#### Devin D. said:

Thank you... My whole day has been wasted trying to fix this issue.  Took forever to uninstall everything, but it did work.

February 18, 2011 7:40 PM

#### Jim B. said:

Thank you for this information - I was going crazy trying to get SQL 2008 R2 uninstalled!

March 4, 2011 2:45 PM

#### Alex B said:

Excellent article.  Being a OSX and *nix admin, I'm constantly flustered by windows uninstall failures, and the mystery locations files get stuck in.  Love it when I can write a script to clean up the MS mess ;)  Next time though, I'll mark my calendar before the 180 days expires!

Cheers!

March 11, 2011 1:35 PM

#### Munshi Verma said:

Aaron! You rooock man!

You saved my day indeed. I have been hitting my head on ways to get rid of those SQL Server 2008 R2 Database Engine Shared and the Common Files, but couldn't until saw your above blog...:)

Thanks a tonn!

Keep up the good work!

Thanks and regards,

Munshi Verma

verma_munshi@yahoo.com

March 19, 2011 12:20 AM

#### Jyotsna said:

Thanks Aaron..

It worked perfect, thanks for sharing this information.

March 27, 2011 7:58 PM

#### Ben said:

Thanks a lot.

You saved me much frustration and time.

Re-installing the OS server was not an option, so your help was invaluable.

April 14, 2011 6:27 AM

#### Johnny_D said:

Thank you, Aaron.

That worked for me, after 24 hours of finding the answer, finally I've found it. Thanks a lot.

April 18, 2011 11:50 AM

#### MARC said:

I have gone through this hell before, however I needed to uninstall again today.  I had no problems uninstalling from Control Panel in Windows 7 - HOWEVER - I stopped IIS on my machine today (God knows why) and had NO problems whatsoever. Luck or the right thing to do, I have no idea !!

April 19, 2011 7:21 PM

#### Raj said:

Thanks a lot.

Great job Aaron....

Finally done, after 24 hours of finding the answer.

April 20, 2011 3:10 AM

#### Chuck said:

Thank for the details instructions.  This worked for me.

April 21, 2011 11:18 AM

#### Aaron Bertrand : Your Denali installation will self-destruct in 5... 4... 3... said:

April 21, 2011 12:30 PM

#### Noravia Rodriguez said:

It could sound strange but for my surprise I went to Control Panel - Uninstall Prgrams - And choose SQL Server 2008 64bits - Change - Remove.

Here was the only place where I could find the instance installed to be able to remove it.

If facing the same please let me know

Thanks

April 22, 2011 1:42 PM

#### anonmemo said:

thank you so much. I THINK it has worked for me, still gotta wait and see lol

May 2, 2011 3:18 AM

#### Marie Haggberg said:

My experience was similar to yours: created a VM, installed the 2008 R2 evaluation edition, then decided to repurpose the VM for use in training. Uninstalled the eval edition (not!) and couldn't install 2008 R2.

Your solution worked perfectly and cleared all the evaluation detritus from the VM. Thank you for this helpful post.

May 6, 2011 12:13 AM

#### Srinath said:

Thanks a lot. It helped me to resolve the issue.

May 15, 2011 3:24 AM

#### Rob Farley said:

If you haven’t been caught by a client (or even yourself) installing SQL 2008 R2 Evaluation Edition and

May 23, 2011 10:04 AM

#### Ilan said:

Thank you so much!

May 24, 2011 3:31 AM

#### yasser said:

Really thank u !

June 1, 2011 10:09 PM

#### KM said:

Thank you! Thank you thank you thank you! Thank you! :)

I thought I was never going to get it to go away!

June 8, 2011 7:39 PM

#### Jeroen said:

You saved my life, many thanks!

June 27, 2011 4:01 AM

#### lanex said:

Thank you Aaron for sharing!!! I had the same pain, but with a happy end, because:

I went through fixes steps on http://www.sqlcoffee.com/Troubleshooting073.htm

Thank you, Alberto Morillo!!! SQLCoffee.com

June 29, 2011 11:10 AM

#### Aaron Bertrand said:

In case you missed my previous post, the CTP3 of SQL Server Code-Named "Denali" is now available. You

July 12, 2011 7:47 AM

#### Date said:

Thank you very much! It works!

July 20, 2011 8:22 AM

#### Mark A said:

I love you and want to have your babies.  Was going absolutely nuts on how to remove this horrid piece of software (or at least the installer is horrid).

August 2, 2011 6:53 AM

Great, helped me a lot :-)

THX from Copenhagen, Denmark....

August 19, 2011 2:09 PM

#### JD said:

Thank you so much!

August 26, 2011 6:32 PM

#### Alex said:

Thank u man!

August 31, 2011 9:30 AM

#### Priya said:

September 6, 2011 3:23 AM

#### drGian said:

I was stuck in this nightmare after not even intending to install the eval version.  had a production box that suddenly stops working and the bosses are yelling.  If I hadn't found these (relatively simply) instructions i'd have been screwed.  Thanks.

September 6, 2011 1:47 PM

#### Jhony said:

Thanks Aaron :)..I was facing same error...and i was trying to resovle this error from past 2 days...finally i read your articles...and it helped me a lot...issue got resolved and installed sql successfully....Thanks a lot again :)

September 7, 2011 4:40 PM

#### KenCov said:

Thanks Aaron, This was very frustrating to say the least.  Your article helped me out tremendously.

September 13, 2011 6:01 PM

#### Anthony S said:

Thank you Aaron.  I wasted two days on this until I found your blog and followed your instructions.  Viola!

September 13, 2011 6:56 PM

#### Bob Hoffman said:

Incredibly useful back door technique. I used it for a related SQL 2008 issue but it looks like it can get rid of any software that refuses to leave by the front door. Thanks so much.

September 22, 2011 3:01 PM

#### VaKa said:

That's great!

Thanks so much.

October 17, 2011 5:29 AM

#### Marc G, said:

I'll jump on the old bandwagon and say thanks Aaron for this solution, I was in the same boat as all y'all and this solution worked like a charm! Rock on!

October 25, 2011 4:09 PM

#### MorpheusMTL said:

Wow! after 2 days lost, this recipe is the best thing I found. In my case I had to sort order to resolve uninstall dependencies, i.e. I had to ask removal of "engine shared" at the top of my batch file list. When I ran the batch file a 2nd time, everything was perfectly remove (unbelievable!). Thanks for sharing, Morpheus

October 26, 2011 11:27 AM

#### Frankanie said:

It work well with a complete f*ck up installation where is impossible to uninstall with a soft and normal way.  After that, SQL 2008 R2 was able to complete all installation without problem.

October 28, 2011 10:10 PM

#### dd said:

You just saved my day. Thank you very much!

October 31, 2011 11:36 PM

#### Aleksander said:

Man, I love you. Thanks so much!

November 15, 2011 4:16 PM

#### Arvand Fazeli said:

since this is the painfull way of doing it i wouldn't suggest doing it.

after i followed ur steps i was stuck with other problems which finally made me to remove every registery associated with sql server but that didn't end pretty well either.

my suggestion is that to use windows "fix it" wich is designed to this taks.

November 18, 2011 9:44 AM

#### Amanda said:

Thank you so much for this fantastic post!

November 20, 2011 10:39 PM

#### AJ said:

You saved my time mate!

November 23, 2011 8:31 AM

#### Evald said:

Thanks!!!

November 23, 2011 9:17 AM

#### Aaron Bertrand : Connect Digest : 2011-12-01 said:

December 1, 2011 9:37 AM

#### Samuel (Brazil) said:

OI Aaron. Queria saber se é possível você acessar meu notebook e realizar esse procedimento. E quanto seria o valor desse trabalho?

December 7, 2011 8:03 AM

#### Jamin said:

December 13, 2011 2:16 PM

#### Rose said:

Thanks so much. it was important ti me...

December 20, 2011 7:55 AM

#### Antonio said:

Perfectly removed that ... software with a simple .bat file.

Thanks so much for sharing your guide!

December 22, 2011 12:50 PM

#### Randy said:

you saved me again sir, Thank you very much

January 10, 2012 5:14 PM

#### Jamigo said:

Thank you very much!!!!

January 11, 2012 4:20 AM

#### Jaids said:

Aaron it works. I had it on WIN7 X86 my issue wasn't the evaluation period error but the sql server engine wasn't working and corrupted. I would go and buy the DEV 49 buks one :-). wtf i learned it hard way wasted a whole week trying Add Remove Program feature.

Thanks again

January 11, 2012 7:53 PM

#### Jaids said:

well if you run the batch file while you have SSIS server running you can get in trouble and it won't delete few registry files. Here we go i am going to delete any thing related to MSFT SQL on this puppy. I wish release team did have a complete documentation around it so people knew before evaluating the application. smh.....

January 11, 2012 8:26 PM

#### Aaron Bertrand said:

My favorite blog post Picking favorites is never easy. While I definitely feel like I had some more thought-provoking,

January 20, 2012 2:55 PM

#### BisschopsG said:

Hi,

Thank you for this, this was exactly the same for me and solve my issye while trying to remove a R2 to put a 2k8 instead.

Regards,

January 23, 2012 5:58 AM

#### Hani Allawnha said:

January 26, 2012 2:29 PM

#### fleep said:

booya.... werked fer me too! PIA but thx

February 4, 2012 10:03 PM

#### David said:

This worked great.  Thank you.

Love the bat file trick.

February 13, 2012 11:38 PM

#### ShelLuser said:

Wonderful tip, thanks a lot!

I also fell into the eval trap. I recently discovered MS' Express versions of IIS and SQL 2008 and because the pg_sql driver with PHP 5.3 (shipped with IIS 7 Express) gave me lots of issues I decided to give the SQL Express a go. Forgetting that 2008R2 eval. was in the way.

Rest is as you described above. Best part: I learned something new here!

This tip went straight into my OneNote bag of Windows goodies.

Thanks a bunch, saved me lots of time and grief!

February 14, 2012 11:12 PM

#### Kelsor said:

Thank you very much Aaron. You're a great help :D

March 3, 2012 11:06 PM

#### Dean said:

Thanks Aaron! I had the same issue that started witn an install of Server 2008 Standard from a DVD that failed because it was looking for a sqlncli.msi for Server 2008R2 on the 2008 DVD. What a mess. Glad to have it behind me now.

March 5, 2012 4:14 PM

#### Dave said:

Aaron - you're a champ, thanks so much for this information it was invaluable...!

March 9, 2012 6:14 AM

#### Banx said:

Genius. Thank You!

March 21, 2012 6:33 PM

#### jeff chen said:

I have the same problem, it bother me a lot, now I have solved it by the way mentioned above, thanks

March 22, 2012 3:52 PM

#### Theo said:

I tried running the bat file but it fails with the message

"_R" is not recognized as an internal or external command, operable program or batch file"

The underscore is a square symbol on screen rather than an alpha character.

I ran the bat file as an administrator, but got same error.

I found the MsDtsServer100 service was running so I stopped it. But still the same error.

The bat file is sitting on C:\ root folder, should it be in a specific folder ?

I created the .bat file using Rob Farley's Powershell Script and the bat file name created is uninstallR2.bat

Has anyone else used Rob's script? and got the above issue.

March 25, 2012 11:29 AM

#### John B. said:

Thank you very much.  I owe you 3 handfuls of hair that have remained on my head...

March 30, 2012 7:49 PM

#### C. said:

My SQL Server installation wasn't even broken, but the uninstaller kept giving me the same selection of features to uninstall over and over. I just wanted SQL Server to be gone completely from my system. Your Howto solved that, thanks.

April 6, 2012 6:07 PM

#### Crocky said:

Same for me!

Big Thank to you...

April 17, 2012 3:25 PM

#### Sean said:

April 18, 2012 5:23 PM

#### P'PLOY said:

โคตรเทพ อ่ะ ใช้แล้ว Uninstall ได้เลยค่ะ ขอบคุณมากนะคะ

April 20, 2012 12:12 PM

#### PJK said:

Your blog ... helped tremendously ... unfortunately Ifound it after I did proceed down the rathole and won't get the time back.  My problem was a 2008R2 upgrade on a cluster that lost some binaries in the ftp ... the upgrade failed at the PONR with the INSTANCE.INACTIVE at the new version and the INSTANCE of the 2008.  Long story short ... I tried repairing, tried upgrading again, unistall of the engine,replication... finally removing the 2008 node from the cluster, removed all the 2008 and got caught in still and the INTANCE.INACTIVE and the final vicous removal of 2008R2 ..  In the wee hours of the a.m.  I came across your blog and finally got the remnants removed via the msiexec.exe /x route... had I found your article earlier ... it would have kept me from removing the node and the 2008.  This article applies to any version of 2008R2 and its removal.

April 22, 2012 2:26 PM

#### PJK said:

Re-title your article ... End the Nightmare of removing 2008R2 and Beyond

April 22, 2012 2:42 PM

#### Romulus said:

Thanks! You saved me a lot of time!

April 22, 2012 3:49 PM

#### Anonymous said:

Thanks a lot ..you are a life savior...

April 24, 2012 1:44 PM

#### David said:

The manual uninstall worked, UGLY, but it worked!

May 7, 2012 5:09 PM

#### Michael_M said:

Hi Aaron,

you just saved my life , ok not my life but my weekend.

Thx.

Michael

May 13, 2012 5:53 AM

#### Axel said:

Hi Aaron

I had success with uninstalling SQL Server 2008 SP1. (Programs and features/View installed updates). After un-install it was possible to either upgrade the edition (maintenance) or to de-install the instances.

Axel

May 27, 2012 8:55 AM

#### ucuncu said:

Hi,

Where will you write command

rem DisplayName

msiexec /x "{guid}"

is in Start->Run

May 28, 2012 2:11 AM

Thanks a lot

May 30, 2012 11:54 PM

#### Daniele said:

Great Works... Many thanks

June 5, 2012 5:25 AM

#### tosc said:

I ran in the same issue by upgrading / uninstalling SQL Server 2012 RC0.

:-) tosc

July 3, 2012 7:19 AM

#### siri said:

please give us  some more needful because while following the same process for uninstallation we are getting error and also only half uninstalltion is done

July 5, 2012 5:51 AM

#### siri said:

i know why it is not displaying my name because i have given you the bad comment so you dont want to publish it.

July 5, 2012 5:54 AM

#### Rocky said:

Thanks a lot Aaron!

It saves me a lot of valuable time.

August 10, 2012 10:30 AM

#### Mikkel said:

Thanks a bunch

August 31, 2012 4:05 AM

GREAT THANKS MAN!

I was trying different things spent a whole day!!! but only your solution worked for me!

Great Thanks again!!

September 8, 2012 12:13 AM

#### Wako987 said:

GOOD VERY GOOD!!!

September 18, 2012 10:48 AM

#### Roberto (Italy) said:

Thanks Aaron!

I've been struggling with this uninstall problem all morning and none of the other "solutions" I found works.

October 18, 2012 11:27 AM

#### Jon said:

Wow, You are hero status. Will be using this for our company since we work with db installs all day. Thank you kindly.

October 18, 2012 11:52 AM

#### Kris Bogaert said:

Thank you for helping to unblock the situation and enabling me to proceed with reinstalls.

October 22, 2012 12:46 PM

#### Martin Tallett said:

Spot on, thanks for your help. The advice sounds good too, I will but the developer version next time.

November 22, 2012 10:05 AM

#### Suwandi Halim said:

Save me alot. Thanks

November 28, 2012 8:06 AM

#### Gary Smith said:

Crumbs, many thanks for this.

December 9, 2012 12:11 PM

#### Jeremy Still said:

Whew! Thank you!

December 13, 2012 12:00 PM

#### mohsen sharify said:

tanx man

you saved my time!

January 7, 2013 7:33 AM

#### Rajendran said:

In my case it is a diff problem. The sql2008 r2 is removed successfully but not from the control panel! Unable to remove the title from control panel. When I install again it is not done.

January 8, 2013 11:56 PM

#### TomB said:

Thanks for the excellent idea, Aaron.  What would you do with a key that has no corresponding GUID?  I see a key "Microsoft SQL Server 10" with a DisplayName value "Microsoft SQL Server 2008 R2", an UninstallString value ""c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\SetupARP.exe" /x86", but no GUID (i.e. no SQLProductFamilyCode).

January 16, 2013 3:41 PM

#### AaronBertrand said:

TomB that depends, is this key preventing you from doing anything? Or is it just cosmetics at this point? Without a GUID it shouldn't actually be able to enforce blocking the install of anything else.

Sounds like a beta of some kind from very early in the 2008 or 2008 R2 lifecycle. Of course you know this, but I'll state it anyway: you should always be installing beta software on a virtual machine or other device that you don't care if you lose, have to wipe/reformat, etc. :-)

January 16, 2013 3:45 PM

#### TomB said:

Thanks again, Aaron, very helpful and an amazingly quick response!  I don't think it was preventing anything.  (I'm definitely practicing on a VM before trying this for a customer.)

January 16, 2013 5:31 PM

#### JamesH said:

Thanks for the info!

January 18, 2013 7:18 AM

#### Charan said:

Thank you sir, I was struggling to uninstall. great help it is.

January 24, 2013 11:50 PM

#### yagao0o said:

It helps me alot.THANKS!

March 4, 2013 11:13 PM

#### Brechbert said:

Thank you so much!!!

March 6, 2013 8:03 AM

#### Dominik Gauss said:

To make things a little easier and uninstall everything SQL Server brought along use this code snipplet. You will need the installation media you used to install sql server.

1. open command prompt (cmd.exe):

2. enter the following lines of code

REM ----------------------------

pushd "path\to\install\media"

for /f "tokens=*" %a in ('dir /b /s /a:-D *.msi') do (

msiexec /x "%a"

pause

)

REM ----------------------------

This will uninstall any msi package sql server installed during setup.

You might want to repeat this once or twice to eliminate any leftover dependencies.

And one last note: Do yourself a favour and reboot inbetween the individual runs.

March 6, 2013 8:19 AM

#### Pratik Vyas said:

this is simply AWESOME:)...Saved a lot of time and money...

April 9, 2013 10:54 AM

#### Robert Schmalz said:

Thank you Aaron.  Add one more poor soul who lost beaucoup time until discovering your solution.  Jesus H. Christ! Microsoft should be ashamed of themselves (but are they ever ashamed? no). I've never seen such a confusing mess before.  Thanks again.

April 16, 2013 4:06 PM

#### HHR said:

thanks a lot. it's work very good

May 19, 2013 3:14 PM

#### Dana in STL said:

Thank you, Aaron, this saved me a ton more trouble than re-installing a whole physical server.

June 4, 2013 2:17 PM

#### NTT said:

Thanks a lot.

June 4, 2013 11:45 PM

#### Lakshmi said:

June 11, 2013 4:53 AM

#### Jochen said:

Thanks for that. Worked very well.

June 13, 2013 10:48 AM

#### Raj said:

Wow! Your solution really helped! You are a rock star!!

July 11, 2013 9:41 PM

thanks alot,its working for me

July 13, 2013 12:11 AM

#### Enoch Robinson said:

This totally worked for me. It was definately a mess that complicated a Crystal Reports Server uninstall. Thank you very much for this article!

July 24, 2013 4:01 PM

#### Marcelo Bezerra said:

man, what a piece of this was this..... well, i really need to say: thank you

September 30, 2013 6:55 PM

#### Michele Simone said:

Thank you very much, Aaron, I was getting crazy with that damn uninstall! Your solution spared me a stomachache...

October 4, 2013 10:37 AM

I didn't read through all these comments but wanted to leave a note about my situation.  I spent a couple hours trying to uninstall SQL 2008 R2 and it never uninstalled completely, which really frustrated me.  I did a repair, which used my new product key but I was still getting the error messages.  I did some searching and finally stumbled on the edition upgrade.

I was getting the "Evaluation period has expired message" too.  I ran the "SQL Server Installation Center" \ "Maintenance" \ "Edition Upgrade".  I had a valid key for Standard Edition and used that.  This worked for me.

October 7, 2013 2:58 PM

#### sql_user said:

This is very much helpful! you save the day. Thank you!

November 20, 2013 3:56 AM

#### Monish Jain said:

Thank you very much Aaron. This is the only way I could uninstall SQL Server 2008 R2 from my machine.

November 20, 2013 5:56 PM

#### Carlo said:

Thank you so much! I was going nuts trying to uninstall SQL Server 2008 R2. Worked like a charm.

December 17, 2013 10:14 AM

#### Thomas C.Vandyke said:

Thank You so much for above info. It's very beneficial for me. It's looks like tech support as usual.

March 10, 2014 3:14 AM

#### Marsha said:

thank you for your notes.  It helped me out.

I have one issue left.  it could be the order of uninstalling the guids.

I have one guid that was for SQL Server 2008 R2 SP2 Database Engine Shared

that would not remove.  it was toward the bottom of my list to delete.

I get error  The error code is 2331. The arguments are: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Bin\{C942A025-A840-4BF2-8987-849C0DD44574}sqlca.dll,  The application has failed to start because its side-by-side configuration is incorrect

also found this message

Activation context generation failed for "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Bin\{C942A025-A840-4BF2-8987-849C0DD44574}sqlca.dll". Dependent Assembly Microsoft.VC80.CRT,processorArchitecture="amd64",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="8.0.50727.4027" could not be found. Please use sxstrace.exe for detailed diagnosis.

Has anyone else had this problem?

thanks

March 18, 2014 5:45 PM

#### Marsha said:

I finally got it to work.  I had to uninstall my sql server 2008 enterprise edition before I could get the sql server 2008 R2 express edition to uninstall.  then I installed sql server 2008 enterprise edition

and restored master and msdb databases.

Alot of work, but my enterprise edition maintenance plans can be modified now.

March 27, 2014 4:32 PM

#### martin ng said:

you stopped me from tearing all of my hair out.

unfortunately, i had already wasted half a day before i chanced upon your article. Now i get to keep my other half of the day and saved my hair. Thanks!

May 19, 2014 10:31 AM

#### Marcos said:

Perfect!

Thanks!

June 30, 2014 3:45 PM

#### Flemming said:

You, Sir, are a god among men! Thank You!

August 7, 2014 5:01 AM

#### Gina said:

Well, I had had gone half a day but at least I still have hair!  Thanks for this, worked like a charm!

September 9, 2014 8:40 PM

#### ATTENTION PLS! said:

To BEST DELETE Database Engine Shared!!

Run first

and then

September 20, 2014 5:36 PM

#### Ugandhar said:

Hi Aaron Bertrand,

Thanks a lot, this is very useful info, I could resolve my problem now.

Pls keep on posting this type of useful info.

Thanks a lot once again...

September 29, 2014 1:30 AM

#### Ugandhar said:

Hi Aaron Bertrand,

Thanks a lot, this is very useful info, I could resolve my problem now.

Pls keep on posting this type of useful info.

Thanks a lot once again...

September 29, 2014 1:30 AM

#### Ugandhar said:

Hi Aaron Bertrand,

Thanks a lot, this is very useful info, I could resolve my problem now.

Pls keep on posting this type of useful info.

Thanks a lot once again...

September 29, 2014 1:30 AM

#### Lía said:

It worked perfectly....thank you very very very much!!!

October 30, 2014 8:06 PM

#### Josh said:

Aaron...job well done my friend!  You just saved me a major headache and hours of hard work.  Very well written post - and it worked like a charm!

December 17, 2014 4:05 PM

#### Eric Peyser said:

Great POST !

if you need a bit more granularity and control without having to skim the .reg, you can also do something like this:

"wmic product get > products.txt"  <-lists all of the packages and obj strings with good info.

The removal procedure is the same as yours or you can use "wmic"

Thank you very much for helping me overcome this nightmare of an uninstall.

~Eric Peyser

December 30, 2014 11:11 PM

#### Eric Peyser said:

To not confuse things I will put this post separate.

You can use notepad++ for marking or ferreting out the blocks of suspect installs in your dump file (products.txt). The search and replace/mark has the ability to search via regex.

~Eric Peyser

December 30, 2014 11:17 PM

#### Arman said:

Thanks so much.

It works for me

January 7, 2015 9:40 PM

#### mehrnoosh said:

Thanks a lot

but some sql dll files have remained

would I have any problem re-installing SQL server?

April 14, 2015 4:05 PM

#### AaronBertrand said:

@mehrnoosh can you be more specific? Just because .dll files are on your system doesn't mean they're being used - not all uninstall routines (especially manual ones like this) actually delete all related files. Did you *try* re-installing?

April 16, 2015 9:26 AM

#### JayJay said:

Hey Aaron, So I had SQL Server 2012 installed while uninstalling SQL Server 2008 R2. I was able to uninstall SQL Server 2008 easily after stopping all of my SQL Server services. Being as paranoid as I am, I decided to repair my SQL Server 2012 thinking that maybe something might have gone missing and once the repairing was done, returned in the Control Panel to find the SQL Server 2008 R2 Setup Support files along with SQL Server 2008 R2 Management Objects. I'm lost.

May 21, 2015 12:26 AM

#### AaronBertrand said:

@JayJay: 2008 <> 2008 R2, did you uninstall 2008 or 2008 R2? You may have to remove additional elements like the setup support files even after successfully removing the database engine. The article above was written to assist when the Control Panel methods don't work.

May 26, 2015 12:33 PM

#### JayJay said:

Oh okay. As I have been looking for answers in the net, several places brought me here so I apologize for getting slightly off-topic and thank you for reaching out. So, I watched a couple of You-Tube videos and it seems that SQL Server 2012 actually came preinstalled with Setup Support files from SQL Server 2008 and Management Objects originally meant for SQL Server 2008 R2. As for your question, I uninstalled 2008 R2. This video shows someone uninstalling SQL Server 2012 with no sign of having 2008 or 2008 R2 in the Control Panel. Skip to 1:40: https://www.youtube.com/watch?v=AgVs6s7dqrg.. To save you from confusion, I wanted to keep SQL Server 2012 in my system so I performed repair and it brought back these two properties back into the Control Panel: 1.SQL Server 2008 Setup Support Files & 2.SQL 2008 R2 Management Objects.

May 26, 2015 11:12 PM

#### Greg said:

Everything uninstalled but I still have SQL Server 2008 and SQL Server Agent 2008 listed in the services.  How do I remove those?

September 6, 2015 2:22 PM

#### Kruti said:

Amazing post. Really helped a lot

September 28, 2015 9:20 PM

#### Karthik J said:

Wow...what a wonderful advise and it really worked like a charm...Thanks a lot Aaron and you really saved my time...once again wonderful article and thanks for sharing

November 5, 2015 11:18 PM

#### DWalker said:

I just ran across this myself -- trying to remove SQL Server Management tools 2014 (which is called Express, which actually came from a management-tools-only installation package).  I wonder if anyone from Microsoft has seen this or has commented to you privately.....

The management tools 2014 were not even listed in Programs and Features (Windows 7).

I needed to install some non-Express features so that SSMS would save the DTSX packages that it creates via the import-export wizard...  sheesh.

Microsoft ought to supply a program to "remove all traces of SQL Server".

March 28, 2016 5:29 PM

#### AaronBertrand said:

March 30, 2016 9:44 AM

#### Rex said:

Thanks! It does work to me.

April 18, 2016 8:11 AM

#### mahnoor said:

just install some new feature from sql 2008 after installation just uninstall there is no need for this method try this

April 28, 2016 11:03 PM

#### Siegfried Keller said:

very good - thank you.

helped me with my rude Unistallation of SQL Server 2008 R2, too.

May 9, 2016 11:04 AM

#### jitendra more said:

Thanks for your post, its saves some productive hr of mine.

May 17, 2016 9:21 AM
 Thanks for sharing your feedback! If your feedback doesn't appear right away, please be patient as it may take a few minutes to publish - or longer if the blogger is moderating comments.
New Comments to this post are disabled