SQL Server Express Management Studio Express 2008[转]

SQL Server Express Management Studio Express 2008

因要使用2008的新功能，就顺带装了一下，发现装完后没有SMSE，找到了这个文章。记录一下。

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:

• SQL Server 2008 Express
• SQL Server 2008 Express with Tools
• SQL Server 2008 Express with Advanced Services

 

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.