Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Manually uninstalling SQL Server 2008 and any SQL Server remnants on a Windows 2008 Server

Posted on 2010-11-16
2
Medium Priority
?
2,452 Views
Last Modified: 2012-05-10
I went here to the following link and found this to follow.
http://support.microsoft.com/kb/955404

I think as long as I follow the two steps I am okay. I wrote the following code to use.
1. CD %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Release
2. setup.exe /ACTION=uninstall /FEATURES=SQL,SQLEngine,Replication,FullText,AS,RS,IS,Tools,BC,BOL,BIDS,Conn,SSMS,ADV_SSMS,SDK /INSTANCENAME=MSSQLSERVER

My question is this.....? Looking at the image below. I assume I need to do the above commands having pointed to : INSTANCENAME=MSSQLSERVER
1. INSTANCENAME=80
2. INSTANCENAME=90
3. INSTANCENAME=100
4. INSTANCENAME=MSAS10.MSCRM
5. INSTANCENAME=MSAS10.SRSC_CRM
6. INSTANCENAME=MSAS10.SRSCCRM
7. INSTANCENAME=MSSQL10.SRSCCRM

Once I run those 7 times with all those Instance names changed for each database that would not install. Then I would think restart and then I can install a new version of SQL Server 2008.

When I do that it get the following Error. I thought I was following this by the book.......
TITLE: SQL Server Setup failure.
------------------------------
SQL Server Setup has encountered the following error:
Instance Name MSAS10.MSCRM for product Microsoft SQL Server doesn't exist. Specify a valid instance name.
Error code 0x84B40002.
------------------------------

I'm I following this correctly. The error makes me think no......obviously. I just do not see the error in what I am doing. Please advise thank you.
SQLListProgramFiles.jpg
SQLListProgramFilesDrillDownInto.jpg
0
Comment
Question by:ruavol2
2 Comments
 
LVL 1

Accepted Solution

by:
advapp earned 1000 total points
ID: 34151014
Having reviewed the article, it seems you ONLY need to set INSTANCENAME="MSSQLSERVER".  Are you familiar with named instances of SQL Server?  Unless you specifically gave it a name when you installed it (and most people don't) then you should only need to use the default value they specified.  Have you tried that and what was the result?
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1000 total points
ID: 34152663
In order to remove MSCRM instance, do the following:

1. Go to Control Panel -> Add/Remove Programs
2. Click SQL Server 2008 and then choose Remove
3. Choose MSCRM instance which would remove all components of MSCRM instance.

Please do note that this would not remove the other instances of SQL Server in your machine.
If MSCRM is not listed, then it indicates that it is either a partial installation or incomplete uninstallation and you can remove MSAS10.MSCRM folder.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
Suggested Courses

810 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