Geeks With Blogs
Matt Roberts Rails and .NET
Tried to install SQL Server 2005 and Visual Studio 2005...thought it would be easy....it wasn't!

I had previously installed the CTP release of VS and SQL Server, so I went down the route of using the un-installer tool thats floating around to remove this lot. That's where it all started going bad... First of all, the uninstall tool looked like it was doing a good job, then it stopped responding. After a few hours I killed it and it looked like all had actually gone OK - in my add/remove programs there were only a couple of things left, so I removed those and thought all was well...

But, it turns out that SQL Server 2005 CTP was still installed, it was just hiding!!! Although it has gone from the add/remove programs its still there! A google search reveals I'm not the only one to have this problem - and led me to this blog: http://blogs.msdn.com/astebner/archive/2005/06/14/429194.aspx. This blog post led me to a tool called msiinv.exe that checks to see what really is installed - and SQL Server 2005 was all over the place! This blog goes on to explain how to remove the installed programs that are hiding using msiexec.exe. Great! So I gave that a go - oh dear, it failed. This time, I got errors when I tried to un-install using msiexec with the product code.... *

So, just before I have up and formatted my hard disk, I spoke to my colleague Dave Davis (I told him I'd mention him :) ). He pointed me to a VERY USEFUL TOOL: Windows Cleanup Utility. This tool is similar to msiinv.exe - it basically presents you with a list of everything that is actually in some state of installed-ness on your PC, and allows you to remove it :) Works very well, and saved the day for me :)

Hopefully this will be of assistance to someone battling to install the latest Microsoft dev tools, without reverting to a full on format!!

* - It turns out that these uninstall errors were all related to the order that you install/uninstall previous betas of sql server 2005 and visual studio 2005. Aaron Stebner kindly pointed me to another blog posting he made here, that explains an alternative process to remove SQL server 2005.

Posted on Sunday, November 6, 2005 2:26 PM | Back to top


Comments on this post: Uninstalling SQL Server 2005 CTP.....fun!

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Thank you! I have been Googling on and off for days trying to figure this out. I finally got a clue when I was using Add/Remove to uninstall MSMXL 6.0. It warned there was a dependency on it from SQL Server 2005 Notification Services. However, this was not in the Add/Remove list. I downloaded and ran the Install Cleanup tool and I am finally able to install SQL Server 2005. Thanks!

-Pat
Left by Patrick Richards on Nov 30, 2005 5:15 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Thanks - Dave Davis - go for the White House :-)
Left by Jorgen Thyme on Dec 04, 2005 9:03 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
I have used several tools without sucess: vs_uninst_betas.exe, sqlbuw.exe, etc...
The sure thing which worked for me is Windows Cleanup Utility. Great posting Matt.
Left by Pierre Donyegro on Dec 26, 2005 1:27 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Thanks for the hint. It saves my complete christmas holidays :-)
Arne
Left by Arne Lagrange on Dec 31, 2005 10:06 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
I installed the windows Install clean up and removed sql server 2005 CTP.But it still exist on start menu.Any idea how to remove all sql components completely after these steps?Thanks
Left by Bet on Jan 05, 2006 3:52 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Hi All, I tried using the Windows Cleanup Utility..no luck! :( I selected all the SQL Server 2005 CTP products to be removed as well as .NET framework & Visual Studio CTP, then hit Remove. It processed for a long time & completed. Now, these products are no more listed by the Utility, but they still exist!!! What do I do now?? Plz help!
Left by Vijaya S on Jan 06, 2006 12:49 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
OMFG! Thank you! I spent 1/2 day looking fro this!!!
Left by LG on Jan 18, 2006 5:21 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
THANK YOU! THANK YOU!
Left by Vicki on Feb 15, 2006 9:44 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Glad to be of assistance :)
Left by Matt Roberts on Feb 16, 2006 3:05 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Sorry it doesn't work ................still exists
Left by Neeraj Gupta on Feb 17, 2006 3:28 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
It didn't work for me!!!! SQL Server 2005 CTP is still in the start menu, although it's not gone from the Uninstall Programs control panel! ARRGGHHH - I will have to Reinstall Windows!!!! :-(
Left by Simon on Mar 02, 2006 1:00 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Hmmmm.

Are you sure you have the right permissions? Try removing all of the associated programs from add/remove programs first, and then the cleanup utility...
Left by Matt Roberts on Mar 02, 2006 4:51 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
OMG I thought I was going to have to wipe this server and start over... Thanks a lot for this information :-D
Left by Dana on Mar 30, 2006 2:13 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Thank you. Microsoft doesn't mention this tool (Windows Install Cleanup Wizard) anywhere and it is exactly what I needed.
Left by Orrin on Jul 10, 2006 3:56 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
great job mr. roberts :-)
Left by that was perfect on Jul 30, 2006 8:00 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Well it worked for me, that was super... I couldn't get SQL 2005 to install it's tools because it ketp complaining that SQL Express was installed...Ran the Windows cleanup and it installed...


Thank you, your de man...
Left by Peter Con Techaholic on Dec 02, 2006 5:50 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Thank you so much! It woked for me before I formatted my disk.
Left by Conch on Jan 21, 2007 5:47 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Perfect! Thank you!
Left by Angelo on Jan 26, 2007 11:07 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
It did not worked for SQL Server 2005 installed on Advaned Sever 2000 platform. Cleaning the componet in Add/Remove and Cleaning it by this cleaner, the track of previous intance still exist. May be I should use another "Instance Name" for SQL server?
Left by Mehdi on Jun 12, 2007 6:54 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
How can Microsoft push/throw people where they can not bring/rescue from ...........damn MS
Left by Prakash on Jul 17, 2007 1:10 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Thank you very much.
Left by Tarek ElAyat on Aug 26, 2007 12:26 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Thank you! This was a life saver. I was starting to pull my hair out!
Left by Xavier on Jan 24, 2008 9:33 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Thank You! Thank You! Thank You! This article was of great help.
Left by Nauman on Jul 17, 2008 12:40 AM

# Thanks Pal
Requesting Gravatar...
Thanks a lot man.. this worked for me saved my day.

Regards.
Left by Sumedha on Oct 04, 2008 6:42 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
thank you so much! You save my day! :)
Left by Keomony on Dec 23, 2008 2:41 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
The Install Cleanup tool was the right way! Thax for the hint! ;)
Left by Jakob on Jan 08, 2009 2:25 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Nice find. Definately a must-have for your digital toolbox.
Left by Chris on May 14, 2009 4:36 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Nice, thank you. I was having problems removing SQL 2005.
Left by Johnson on Jun 28, 2009 1:54 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
When you lay down with dogs, you get up with fleas. Microsoft, aka Mickey Mouse, is a dog.
Left by Smith on Aug 05, 2009 2:03 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Thanks a lot. This is awesome. You just save my time. Thanks again. God bless you.
Left by Moinur on Jan 11, 2010 3:39 AM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
Thank you for the great information, but every time I try to remove components I'm getting a runtime error. Microsoft is disappointing as always.
Left by Ben on Feb 06, 2010 6:32 PM

# re: Uninstalling SQL Server 2005 CTP.....fun!
Requesting Gravatar...
If you tried Installing SQL Server 2008 or SQL Server 2005 with System which have already installed SQL Server then It will be difficult to Install new Sql Server.This problem caused by you are Overriding Sql Instance,

http://www.indiatodayonline.com/2010/07/uninstall-sql-server-completely-remove.html
Left by mani on Jul 14, 2010 3:00 AM

Your comment:
 (will show your gravatar)


Copyright © Matt Roberts | Powered by: GeeksWithBlogs.net | Join free