Solved

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

Posted on 2010-11-10
9
768 Views
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
ListOfInstalledApplications.png
0
Comment
Question by:ruavol2
  • 6
  • 3
9 Comments
 
LVL 35

Accepted Solution

by:
David Todd earned 500 total points
Comment Utility
Hi,

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?

Regards
   David

PS Is this a workstation, production server, what?
0
 

Author Comment

by:ruavol2
Comment Utility
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.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_26548338.html

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.                      
0
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 500 total points
Comment Utility
Hi,

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.

Regards
  David
0
 

Author Comment

by:ruavol2
Comment Utility
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.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:ruavol2
Comment Utility
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.
0
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 500 total points
Comment Utility
Hi,

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>

HTH
  David
0
 

Author Comment

by:ruavol2
Comment Utility
Here is what I get when I try to uninstall SQL Server Management Studio. I followed this link. http://support.microsoft.com/kb/909953
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.
0
 

Author Comment

by:ruavol2
Comment Utility
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.
LatestScreenShotWithSQL2005Remov.jpg
0
 

Author Closing Comment

by:ruavol2
Comment Utility
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.
0

Featured Post

Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
OfficeMate Freezes on login or does not load after login credentials are input.
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 the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now