Solved

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

Posted on 2010-11-16
2
2,320 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 250 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 250 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to remove users in file list from specific AD group? 3 40
Remove Extension 3 37
Windows Password recovery 7 36
Separate 2 comma delimited columns into separate rows 2 31
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
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…

773 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