Link to home
Start Free TrialLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on

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

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
ASKER CERTIFIED SOLUTION
Avatar of David Todd
David Todd
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RUA Volunteer2?

ASKER

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.
https://www.experts-exchange.com/questions/26548338/SQL-Server-2008-Setup-has-encountered-an-error-Has-anyone-seen-this.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.                      
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
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
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.