Set up MSSQL Server 2008 Management Studio SSMS2008

It is quite convenient to use a GUI tools to manage the database. E.g. SQL Server Management Studio.

If you have installed SQL Server 2008 when you try to connect it with “SQL 2000 Enterprise Manager” You may receive a message to ask you to use Management Studio…etc.

When you search for MS SQL Management Studio 2008, you may be able to find a link for you to download Management Studio 2005
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796

If you want to use MS SQL Server 2008 Management Studio. You would need to download “SQL Server 2008 Express with tools” or “SQL Server 2008 Express with Advanced Services”. Or if you have a copy of SQL Server 2008 (Not the express edition), you can install it there.

You can go to the following URL to download SQL Server 2008 Express Edition
http://www.microsoft.com/express/sql/download/

After you download SQL Server 2008 Express with Tools or Advanced Services.

You can go throught the installation process.

  1. Run the “.exe” file
  2. Then click on Installation on the Left hand side menu.
  3. Select “New SQL Server stand-alone installation or add features to an existing installation”
  4. Then run throught the process to install the setup file and finish all the checking…etc
  5. (E.g. Click “Next”, “Next”, “Next”,…etc)
  6. Then you will see the “Installation Type” screen as below.
  7. Select “Add features to an existing instance of SQL Server 2008” (if you already installed SQL 2008) Or “Perform a new installation of SQL Server 2008” if you just want to use the tools
  8. If you selected “Perform a new installation of SQL Server 2008” you will see another screen about License Agreement
  9. After you agree the license you will see the following screen.
  10. Select “Shared Feature” -> “Management Tools – Basic”
  11. If will carry on ask you several question about when do you want to install to …etc.
  12. After gone through all the “Next”, “Next”, “Next”.

–>“Disk Space Requirement”

–>“Server Configuation”
–>“Error and Usage Reporting”
–>“Installation Rules”

13. Then you will come to a screen about “Ready to Install”
14. After you click on Install. It will process the installation.
15. Finally, you will see Management Studio on you “Start Menu”

Have fun.

Leave a Reply