Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I tried upgrading SQL Server Express 2008 to SP1, but the Setup was very far from clear. I ended up with 2 database engines.

I now want to install Management Studio Express, but it apparently means I have to create yet another database engine.

How do I remove these existing ones? I want to name it SqlExpress but I can't because it already exists.

enter image description here

When installing, I have to select "Perform a new installation...", otherwise I won't be able to see "Management Tool - Basic".

enter image description here

And I don't see Database Engine selection

enter image description here

Add/Remove Programs screenshot: enter image description here

Thank you for your replies!

share|improve this question
    
You don't need to install another instance when installing management studio. When you get to the component selection screen, only select management tools, uncheck database engine. –  Sam Aug 29 '11 at 12:12
    
Thanks Sam, but it's not there, I updated the question with more screenshots, thanks! –  aximili Aug 29 '11 at 13:11
    
if it's not listed there then the installer does not contain the database engine, so it won't install another instance. –  Sam Aug 29 '11 at 20:26
    
But it just created another instance (of whatever it's called if it's not database engine). Please see my screenshots. And thanks! –  aximili Aug 31 '11 at 4:55
add comment

2 Answers

up vote 2 down vote accepted

If you already have an instance installed on the "Installation Type" screen select Add components to an existing instance.

To remove the second instance, you need to go into add/remove programs and run through the wizard to remove an instance.

share|improve this answer
    
Thanks! The same wizard as for the installation? I tried that, there is no option to remove it. –  aximili Aug 30 '11 at 14:11
    
To remove an instance go into add remove programs and run through the removal process from there. –  mrdenny Aug 31 '11 at 0:24
    
Thanks but... what do you mean by "run through the removal process from there"...? I have put a screenshot of what I see in Add/Remove Programs, I cannot see the SQL Server instance there. –  aximili Aug 31 '11 at 4:54
1  
Use the one labeled "Microsoft SQL Server 2008 (64-bit)" –  mrdenny Aug 31 '11 at 8:08
    
Perfect!!! Thanks a lot!! –  aximili Sep 1 '11 at 10:49
add comment

Just download the SQL Server Management Studio Express (stand-alone) installtion from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=8961

Uninstall your second SQLExpress instance using Add/Remove programs

share|improve this answer
    
It is not in Add/Remove Programs, I'll post the screenshot now to the question. –  aximili Aug 30 '11 at 14:10
    
Btw that download link is for 2005, do you have one for 2008 that is standalone? And thanks btw! –  aximili Aug 30 '11 at 14:12
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.