News

Copyright © 2008-2018 Paula DiTallo

Tag Cloud



How do I remove a named instance of sql server 2008 on the same mssql server?

I recently needed to work with SSIS on my laptop with an existing SQL Server 2008 Express instance. I did not setup the service accounts correctly on the SQL Server 2008 Development install--so needed to remove the corrupt install.

There doesn't appear to be much documentation on this—well, if there is, then I didn't key in the best search criteria! Anyway, the removal of a named 2008 instance is an easy set of steps, although nervous-making--since you'll be uninstalling Microsoft SQL Server 2008 without any initial guidance.

Here are the steps you will need to take:

1. Navigate to Control Panel->Add/Remove Programs

2. Select Microsoft SQL Server 2008

3. Select Change/Remove

4. Select Remove

You will be asked for a specific instance. This is where you type in the name of the instance you want to remove. DON'T get click happy on what to de-install. Click ONLY on the items that specify your named instance. LEAVE all the SHARED features. If you delete them, you'll corrupt your other installations on that server.

Thursday, November 3, 2011 2:28 AM

Feedback

# re: How do I remove a named instance of sql server 2008 on the same mssql server?

Nice and Easy Answer.
Helped me quickly 11/20/2012 5:50 AM | Kiran

# re: How do I remove a named instance of sql server 2008 on the same mssql server?

Thanks, thanks, thanks 3/19/2014 5:57 AM | hk

# re: How do I remove a named instance of sql server 2008 on the same mssql server?

Worked Thnks 4/24/2014 10:48 AM | Joshua

# re: How do I remove a named instance of sql server 2008 on the same mssql server?

Thanks for the quick and easy answer. 9/30/2014 9:36 AM | Pablo

# re: How do I remove a named instance of sql server 2008 on the same mssql on windows server 2008 r2 server?

But i have remove old instance only through registry 3/5/2015 4:25 AM | ilesh Kinge

Post A Comment
Title:
Name:
Email:
Comment:
Verification: