How do I uninstall SQL Server 2008 components safely without disturbing any databases.

Posted on 2010-11-10
Last Modified: 2012-05-10
What applications / programs do I need to uninstall so that I can reinstall SQL Server 2008. I have been getting errors for a while now and the install keeps failing again and again. Any help is greatly appreciated. Thank you. See images below
Question by:ruavol2
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
LVL 35

Accepted Solution

David Todd earned 500 total points
ID: 34110118

What edition of SQL 2008 are you trying to install? If not express, then its likely that Management Studio Express is blocking your install.

I suggest thatas well the Compact Edition could be uninstalled.

What do you need from SQL 2005?


PS Is this a workstation, production server, what?

Author Comment

ID: 34111906
This is a server. So you are saying I just need to remove Management Studio Express and the Compact Edition and start over.

A product called Time Force was originally installed on the server that keeps up with a punch cock for a manufacturing plant. I cannot mess that up.

I was trying to install SQL Server 2008 Standard Edition. I was told by EE that I could start the install for SQL Server 2008 Standard Edition SP1 that it would install some files for SP2. Then I would need to stop the actual install. Then I should go back and run the SQL Server 2008 Standard Edition install and it would take those updates and actually install SQL Server 2008 SP2. That is from this thread. The comment is below it. 

PenguinN:                                                    What release of Windows 2008 are you installing  on. In case of windows 2008r2 you'll need sql 2008 sp1. If you want to  install without servicepack. Run the installer of sql sp1, it will  complain there is no SQL but extracts the files, once the files are  extracted cancel out of here. Now you can install SQL 2008 (without  servicepack) and it will pickup the SQL files and install SQL, once the  installation is finisched rerun the SP1 setup and youl find yourself  with a working SQL on release 2008R2.                      
LVL 35

Assisted Solution

by:David Todd
David Todd earned 500 total points
ID: 34113854

If you have a look at the last two screen-shots on your other question is what I'm talking about here - SQL Express Tools is blocking the SQL Standard install.

In the first instance I wouldn't be asking this on EE, I'd be asking the vendour of Time Force.

I write this in my profile:
Please take all due care with suggested queries and procedures. That is, test them on test systems first. Make sure that you have current backups of production and system databases.

Can you create a test copy of this server and experiment on that? The recommendation by Penginun doesn't sound right. What I mean is, in the past there have been versions that to be supported needed particular service packs etc. But the way forward was simple - not a stop the install and point A. It was compelte the install, and then apply service packs (x through z) say.

I can't see that running the service pack install will actually achieve anything.

Anyway, removing Management Studio Express will allow the SQL Standard install to proceed. When that completes you'll have the full management tools which should be able to do everything and more than the Express tools do.

Maybe leave the compact edition for now. I suggest removing it as it always manages to get installed with something, and I've never seen it used. Its just taking up real-estate. But maybe, this is what Timeforce is using.

Talk to Time Force, and check this out with them. I can't rule out that they use something out of the express tools. In pure database terms, uninstalling the tools should be fine.

Bottom line: if its an existing server in production, you don't want to mess around with it. Get the vendours insight and test.

One last thought - if this server has a busy application already, is this the best place to deploy a production instance of SQL Server? Hardware is cheap.

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!


Author Comment

ID: 34122527
Most thorough answer  I have ever received on EE. You should be a marriage councellor. There would probably be less divorce rates if you did. Thank you. I am going to try to get this done again else I am reverting back to the SQL 2005 standard edition and see if I can get the full install of that on. I will respnd soon as I try this. I physically at the server today. I was remoting in all the other times.

Author Comment

ID: 34122654
Also when you say remove  SQL Express Tools . SQL Express Tools is blocking the SQL Standard install. I am not seeing a tool called exactly that SQL Express Tools..? Is that one tool I need to find and remove or a series of tools I need to uninstall. If so which ones are they?

Second thought . Do you mean that the Compact Edition is part of that list.
TimeForce was installed with SQL 2005. I just noticed that when I tried to install it the TimeForce Database poped up. I am 100 % sure it was setup there. Any thoughts are greatly appreciated. Thank you.
LVL 35

Assisted Solution

by:David Todd
David Todd earned 500 total points
ID: 34123144

In Add/Remove programs it is
Microsoft SQL Server Management Studio Express
from the screen shot above.

This corresponds to
Rule "SQL Server 2005 Epxress tools" failed
from the installation setup screen shots in the other question

Of course this is confusing calling the same thing by 15 different names ... <grin>


Author Comment

ID: 34124778
Here is what I get when I try to uninstall SQL Server Management Studio. I followed this link.
Then I saw your instructions.
OKAY here is the really funny thing. SQL Server Management Studio is not listed as it was in the list above. Now I am baffled. I went into the install again to see if it would fail and the last database I tried to setup is actually there now......I am really confused.

My ultimate goal was to install Microsoft CRM. So I created a database called CRM. The database I created is there with the latest version 2008 listed. Any other thoughts.

Author Comment

ID: 34140818
Here is the latest ScreenShot. I have been able to uninstall SQL Server 2005. However I have been getting stuck over and over again with the same issues. Is there any way to safely manually remove SQL Server 2008 and just start over.

Again I have tried to install and uninstall so many times. It is just not working. Here is what is left on the server. If there is a sequence I will try it. I have again tried installing all components several times over. No love from the Server yet. Here is what is left please advise if you can.

Author Closing Comment

ID: 34167604
I think it worked in part. I was able to manually go in and uninstall the various components and the seemed to have been removed at least on the surface. I used a tool Revo Uninstaller and it seemed to have gotten the rest out. Registry keys and all. I restarted and it appeared to be gone. Thank you.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server Serialization error 8 47
SQL Server 2005 running VERY slowly on new hardware 22 62
Remote Desktop Terminal License Issue 5 50
Active Directory Powershell Script 9 41
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question