SQL Server Management Studio 2008 install - no option

Question

Ok I've searched everywhere for an answer and can't seem to find an answer.

I've installed VS 2010 and with it came SQL Server 2008 Express. I am currently trying to install SQL Server Management Studio 2008 and it won't give me the option to install.

At first, I thought it wanted me to install SP1 first.. but it says there is nothing to patch!

My SQL patch version: 10.1.2531.0

EDIT: This is the installer I'm using: http://www.microsoft.com/en-us/download/details.aspx?id=7593

Answer 1

I ran into this glitch, too. The Shared Features selection list should show [✓] Management Tools - Basic. The checkbox was auto-filled.

I rebooted, then ran the installer as an administrator and it worked as expected.

Answer 2

I was having the exact same problem with my installation for SQL Server 2008 R2 RTM - Management Studio Express. Go back to the "Installation Type" step (the previous one), and closely read the text under each radio button. The option under the "New installation or add shared features" reads:

Select this option if you want to install a new instance of SQL Server or want to install shared components such as SQL Server Management Studio or Integration Services.

You have to select "New Installation", and not "Add Features", as counterintuitive as this may seem.

Answer 3

Back up one step and choose the "Perform a new installation" option. Brilliant, I know.

Answer 4

As far as I remember Management Studio is not bundled with every version of SQL Serever 2008 Express installator. Maybe you could try to install this: Microsoft® SQL Server® 2008 Management Studio Express or this Microsoft SQL Server 2008 R2 RTM - Management Studio Express depending on your version of server.