To Download the SQL Server Express Management Studio Express 2008 for SQL Express 2008 R2:
(Begin June 2011 Update)
| |
Database Only |
Management Tools |
Database with
Management Tools |
Database with
Advanced Services |
| SQL Server Database Engine |
 |
|
|
|
| SQL Server Management Studio Express |
|
|
|
|
| Full-Text Search |
|
|
|
|
| Reporting Services |
|
|
|
|
| Download Size ( 32-bit | 64-bit ) |
58.1 MB | 74 MB |
154 MB | 163 MB |
235 MB | 247 MB |
727 MB | 795 MB |
| Install |
  |
|
|
|
(End June 2011 Update)
I was recently doing a personal site and wanted to use VWD and SQL Express, this time all 2008.
All happy and fine went to the site and downloaded and selected to install SQL Exrpress 2008.
Went to look for SQL Server Express Management Studio Express 2008 annnnnd nothing!
Few search engine searches later and no clear direction found this on SQL Express home page:
|
You can manually download and install any edition of SQL Server 2008 directly from the Microsoft Download Center:
|
Which edition of SQL Server 2008 Express is right for you?
SQL Server 2008 Express is available in the following 3 editions (each is available from the Install Wizard):
- SQL Server 2008 Express
- SQL Server database engine - create, store, update and retrieve your data
- SQL Server 2008 Express with Tools
- SQL Server database engine - create, store, update and retrieve your data
- SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases
- SQL Server 2008 Express with Advanced Services
- SQL Server database engine - create, store, update and retrieve your data
- SQL Server Management Studio Basic - visual database management tool for creating, editing and managing databases
- Full-text Search - powerful, high-speed engine for searching text-intensive data
- Reporting Services - integrated report creation and design environment to create reports
|
So make sure you download the SQL Server 2008 Express with Tools
Though I save some people some time.
One last thing:
Step 1: Download and install Microsoft .Net Framework 3.5 SP1.
Step 2 Download and install Windows Installer 4.5 [important of you have pre-Vista OS].
.
Step 3 Download and install Windows PowerShell 1.0.
And one more thing: If you have non-SP1 version of Visual Studio 2008, you will be stopped at the very last step before the install begins!!! So if you have VS2008 or any 2008 Express products, upgrade them to SP1 to install the Tools version to get your Management Studio Express.
UPDATE:UPDATE:UPDATE:UPDATE:UPDATE:UPDATE:UPDATE:UPDATE:UPDATE:
A commenter by the name of "matt" has an update:
I FOUND A SOLUTION TO THE PROBLEM ABOVE ME
1. If you run "SQLManagementStudio_x64_ENU.exe", you'll come across a "SQL Server Installation Center" window.
2. You normally click at the "Installation" tab on the left pane, and click "New SQL Server stand-alone installation or add features to an existing installation".
3. A "SQL Server 2008 Setup" installation window appears, and have the following steps included:
- Setup Support Rules
- Installation Type
- Product Key (depending on the type of installation type you selected)
- and so on...
4. Once you get to the "Installation Type" step of the installation, instead of adding a new feature to the existing SQL Instance (that I initially setup as SQLExpress), try the install new instance, or something to that effect. There are only two options in this portion, so it won't be difficult to select.
5. Click next until you reach the "Feature Selection" step of the installation. There, select only the "Management Tools" checkbox (or something that relates to the Management Studio). And, in my case, the "Client SDK" checkbox was automatically checked. Uncheck the first two checkboxes that have something to do with a new SQL Instance. You won't need that anymore because you've installed that earlier.
6. Install on and be done! :)
I hope this helps... please post replies if this worked or not.