1

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!

Improve this question
4
  • 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. Commented Aug 29, 2011 at 12:12
  • Thanks Sam, but it's not there, I updated the question with more screenshots, thanks! Commented Aug 29, 2011 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. Commented Aug 29, 2011 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! Commented Aug 31, 2011 at 4:55

2 Answers 2

Reset to default
3

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.

Improve this answer
5
  • Thanks! The same wizard as for the installation? I tried that, there is no option to remove it. Commented Aug 30, 2011 at 14:11
  • To remove an instance go into add remove programs and run through the removal process from there. Commented Aug 31, 2011 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. Commented Aug 31, 2011 at 4:54
  • 2
    Use the one labeled "Microsoft SQL Server 2008 (64-bit)" Commented Aug 31, 2011 at 8:08
  • Selecting the (64-bit) version also fixed this issue for me on SQL Server 2012. Commented Aug 25, 2015 at 13:35
2

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

Improve this answer
2
  • It is not in Add/Remove Programs, I'll post the screenshot now to the question. Commented Aug 30, 2011 at 14:10
  • Btw that download link is for 2005, do you have one for 2008 that is standalone? And thanks btw! Commented Aug 30, 2011 at 14:12

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.