?
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,392 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
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 walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

765 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