Install SQL Server 2008 Management Studio Express

Published on Tuesday, May 31, 2011

For Microsoft languages developer, SQL Server 2005 / 2008 Management Studio Express is a required database management tool.

But, at least for SQL Server 2005 / 2008 Management Studio Express, people all complained it is not easy to install, we always got error or trouble to install it.

Here let us try to do one more install process and try to find a correct installation way.

The downloading place:

We searched out 2 places, both of them are Microsoft Official sites: Here and Here (R2).  We see the different header on the 2nd page is “Microsoft SQL Server 2008 R2 Express” but the 1st place no, so we suppose we should download from the 2nd one.

installSQLStudio00

Please Do NOT click the 64-bit or 32-bit button directly if you only want to install Management studio, click "Other Installation Option". In the  next page, only select Management Tools column to download.

installSQLStudio01

After download, just double click the file to install:

image

Because we have already installed Visual Studio 2010, a SQL Server Express 2008 version has been installed, but it should be R1, not R2, so we select “New installation or add features to an existing installation” since it will install SQL Server 2008 R2 or to add features to an existing SQL Server 2008 R2.

(Note: If you select **“Update from SQL 2000, SQL Server 2005 or SQL Server 2008”, **you might get error or installation failure later. Because this is what we met lots of time before. and, people found the reason might be "the Management Studio can only be installed during installation of the first instance." please check here)

installSQLStudio02

After short while for processing, we got the first windows to accept license term, we see this term is for SQL Server Management Studio Express.

installSQLStudio03

The Setup Support Files will be installed …

installSQLStudio04

Now it asks you reboot your computer since it found affected files have operations pending:

installSQLStudio05

After we reboot our computer, double click our downloading file and run it again. later we will go back to the previous screen which we saw before we reboot computer,  and then go to the Feature selection window, we can see the SQL Server Management Studio is going to be installed:

installSQLStudio06

Then go to Error Reporting screen, this is not an error now, that is for whether you want to send error reporting to Microsoft in case of you meet errors:

installSQLStudio07

Now the installation progress:

installSQLStudio08

Finally, we got completed screen. this time we are lucky, we no more got error screen, but we knew this, because we are install new SQL Server database instance.

installSQLStudio09

We can double check in our Start menu in Windows:

installSQLStudio10