Monday, July 20, 2009

Installing SQL Server Management Studio

I recently installed Visual Studio 2010 Beta on my Notebook computer with Vista Home Premium. SQLServer Express 2008 that comes with VS2010 Installation has only two tools.

  • It has only Import and Export Data (32bit)
  • SQL Server Configuration Manager
You could download the following:


If you think you will be installing the Management Studio you will be fooled (this was probably created for the April 1 downloaders)

Here are the screen shots of what it really tried to install.
May be the following download may contain the Management Studio.

SQLEXPRADV_x86_ENU.exe (502.7 MB)
Brief description of the above lifted from Microsoft documentation to quote:

"Microsoft SQL Server 2008 Express with Advanced Services is a free, easy-to-use version of the SQL Server Express data platform that includes an advanced graphical management tool and powerful features for reporting and advanced text-based searches. This edition provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for small server applications and local data stores."

Now back to the installations shots of the one that had the name but no tool:
The installion verifies as successful 13 operations in the Setup Support Rules checking.
What the program has is shown here:

The SDK is greyed out and choosing any of these produces an exception.
If you try to search for the SQL Client Connectivity SDK mentioned you will hit a hardwall.
Well done Microsoft.


jlahey.personal said...

Good couple of posts on this topic. How do you know whether to get the 64 or 86 version? There is no guidance on the Microsoft page. My Vista Home Premium is running 32-bit but is 64-bit capable, so I assume that I need the 64 version. Thanks!

Jayaram Krishnaswamy said...

I would personally go with x86. Protection Status