Can't install SQL Server mangement studio express

Question

When i try to install SQL Server mangement studio express I get the error:

There are validation errors on this page, and the error on the page says:

To continue one or more features must be selected.

But it looks like the features are selected.

Thanks

Answer 1

Hi allan,

Please check if you installed SQL Server 2008 Management Studio Express or SQL Server 2008 Express.
If you installed SQL Server 2008 Express, please follow the below link steps.

How to install SQL Server 2008: http://www.sqlcoffee.com/SQLServer2008_0013.htm.

Download SQL Server 2008 Management Studio Express: http://www.microsoft.com/download/en/details.aspx?id=7593.

If you have any problem, please feel free to let me know.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 2

Could you please post the screen shot it possible, it will help to understand in a better way.

Also please try to download Sql Server 2008 R2 from here http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

---

Thanks
Manish

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 3

• you better do nothing. just when the error page comes go back and select new installation (not the add features to option) and go on. Then on the page where error was coming you will notice that a check box Management tools basic is unchecked. Select it and then go on. All will goes well.

• If only your SSMS is corrupted then do a fresh installation http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796

Answer 4

I have tried all these options but it is still not working, however, I noticed this error in the event log:

 

The application (Microsoft SQL Server 2008, from vendor Microsoft) has the following problem: After SQL Server Setup completes, you must apply SQL Server 2008 Service Pack 1 (SP1) or a later service pack before you run SQL Server 2008 on this version of Windows.

But I have applied the SQL Server SP1, how do i verify that SP1 was installed successfully?

Kindly,

Answer 5

Are you able to connect to SQL Server by any other means, say, sqlcmd? If so, try

select SERVERPROPERTY('ProductVersion') as Version, SERVERPROPERTY('ProductLevel') as [Level]

If you installed SP1, Level should show SP1.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 6

Hi allan,

Please check if you have installed SQL Server 2008 Service Pack 1.

If not, please download Service Pack 1 from http://www.microsoft.com/download/en/details.aspx?id=20302.

Reference: http://support.microsoft.com/kb/955725.

 If you have any problem, please feel free to let me know.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 7

thanks,

I went into SQLcmd and ran that command but nothing happend.

should i run that command exaclty as you have typed it?

Kindly

Answer 8

No, this is a query which should be run as part of the whole command.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 9

Thanks for the quick reply,

But i dont understand what you mean.

And i am sorry, it is my lack of knowledge, but in sqlcmd how exaclty do i do this?

 

Answer 10

Here is what I just tried:

Typed cmd in the Windows/Start button.

Then typed

sqlcmd -q "SELECT SERVERPROPERTY('ProductLevel') as [Level]"

I got the output on the screen (after many -------------) showing SP1.

For details about sqlcmd syntax check http://msdn.microsoft.com/en-us/library/ms180944.aspx

 

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 11

Also, this may be irrelevant to your problem, but perhaps it may help

Rule "Previous releases of Microsoft Visual Studio 2008" failed

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 12

Hi allan,

You could run a new query “SELECT @@VERSION “in SQL Server Management Studio. If you have installed SQL Server 2008 Service Pack 1, the version number will be 10.00.2531.00.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.