Solved

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

Posted on 2010-11-16
2
2,303 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
Comment Utility
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
Comment Utility
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In this article I will describe the Detach & Attach 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.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
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 enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

763 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

12 Experts available now in Live!

Get 1:1 Help Now