Installing Microsoft SQL Server 2008 Management Studio Express

Microsoft SQL server 2008 Management Studio Express offers management tools for Microsoft SQL Server 2008 Express, Express with Advanced Services and Compact editions. If your database is hosted on an SQL 2005 Express server, install Microsoft SQL Server Management Studio Express. SQL server 2008 Management Studio Express runs on Windows 7, Windows Vista service pack 1 and Windows XP service packs 2 and 3, Windows server 2003 service pack 2, Windows server 2008 and Windows Server 2008 R2.

This article includes instructions for installing all of the necessary prerequisites. Each installation will be different depending upon the operating system, patch level and previous software installations on the computer. You must log in to the computer with administrative rights to install software.

Install Windows Installer

1. Download the appropriate installation file for your version of Microsoft Windows from the Microsoft Download Center.
2. http://www.microsoft.com/download/en/details.aspx?id=8483 is the 4.5 Installer for SQL 2008 Studio!
3. Open the Windows installer file.
4. Click “Next” when presented with the “Software Update Installation Wizard.”
5. Select the option beside “I agree” to answer the licensing agreement query.
6. Click the “Next” button.
7. Press “Finish.”

Install the .NET Framework

1. Download the current version of the .NET Framework for your operating system from the Microsoft Download Center.
2. Open the .NET Framework installation file.
3. Select the option button for “I have read and accept the terms of license agreement” to agree to the licensing terms.
4. Press “Install.”
5. Click “Exit” when the message that the setup has completed appears.

Install Windows PowerShell

1. Download Windows PowerShell for Windows XP or for Windows 2003 Server from Microsoft's download center.
2. Execute the Windows PowerShell setup file.
3. Click “Next” in the Software Update Installation” window.
4. Select “I Agree” to accept the licensing agreement. Click “Next.”
5. Press “Finish” when the installation has completed successfully.

Install Microsoft SQL Server 2008 Management Studio

1. Download Microsoft SQL Server 2008 Management Studio Express from the Microsoft Download Center.
2. Double-click the Microsoft SQL Server 2008 Management Studio Express executable file.
3. Choose “Installation” in the SQL Server Installation Center window.
4. Click on the link to “New SQL Server stand-alone installation or add features to an existing installation.”
5. Check for warnings and errors in the “Setup Support Rules” pane.
6. Resolve any failures before clicking the “OK” button.
7. Click “Install.”
8. Check for warnings and errors in the “Setup Support Rules” pane.
9. Resolve any failures before clicking the “Next” button.
10. Select “Perform a new installation of SQL Server 2008.” Click “Next” and “Next.”
11. Check the box beside “I accept the license terms.” Click “Next.”
12. Check the box beside “Management Tools – Basic” beneath the shared features.
13. Click “Next” and “Next.”
14. Accept the defaults in the “Error and Usage Reporting” screen and click “Next.”
15. Select the “Next” button and click “Install.”
16. Click “Next” and “Close” when you see the message that the setup process is complete.

Microsoft SQL 2008 Server Management Studio Express simplifies management of SQL 2008 Server Express and Compact editions. Authorized users and administrators can run scripts, create tables, assign rights, schedule backups, replicate, shrink and restore databases from the Object Explorer window. While a long process, installation of the prerequisites and the software will save you time and effort when administering your SQL databases.

Copyright from Maria Montoya’s suite 101 site: Installing Microsoft SQL Server 2008 Management Studio Express | Suite101.com