SQL Server FAQ – Downloading and Installing SQL Server Management Studio Express

Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ – Downloading and Installing SQL Server Management Studio Express

By: FYIcenter.com

(Continued from previous topic…)

How to download and install Microsoft SQL Server Management Studio Express?

Microsoft SQL Server Management Studio Express (SSMSE) is a free,
easy-to-use graphical management tool for managing SQL Server 2005 Express Edition
and SQL Server 2005 Express Edition with Advanced Services.
If you want to download and install it to your system, follow this tutorial:

1. Go to SQL Server Management Studio Express home page.

2. Go to the “Files in This Download” section.

3. Click the Download button next to “SQLServer2005_SSMSEE.msi – 38.5 MB”
And save it to c:\temp directory.

4. Look at and compare the downloaded file properties with:

Name: SQLServer2005_SSMSEE.msiLocation: C:\tempSize: 40,364,032 bytes

5. Double click to install. The setup window shows up.
Follow the instructions to finish the installation process.

6. When installation is done, you will see a new program menu entry as:
Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express

(Continued on next topic…)