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!

Aximili
  • 113
  • 1
  • 1
  • 6
  • 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 Cogan 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 Cogan 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 04:55

2 Answers2

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.

mrdenny
  • 27,074
  • 4
  • 40
  • 68
  • 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 00: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 04:54
  • 2
    Use the one labeled "Microsoft SQL Server 2008 (64-bit)" – mrdenny Aug 31 '11 at 08:08
  • Selecting the (64-bit) version also fixed this issue for me on SQL Server 2012. – BenCes Aug 25 '15 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

Joel Mansford
  • 985
  • 1
  • 5
  • 13