How to Install a Microsoft SQL Server Management Console

SQL Server Management Studio (SSMS) is a tool used to manage your databases. You can manage a database on the location server, or you can use SSMS to connect to a remote database on the network and manage the tables, stored procedures and general settings. You can install the utility directly from your SQL Server installation DVD. SSMS is included with SQL Server 2005 and 2008.

Instructions

1

Insert the installation DVD in the computer's drive. The autoplay feature automatically opens a splash screen that asks you if you want to install the software. Click the "New SQL Server stand-alone installation or add features to an existing installation" option to get started.

2

Type the product code located in the installation DVD package. If you install the free Express edition, the product license option is grayed out. Click "Next".

3

Check the box next to "Management Tools - Basic" and "SQL Client Connectivity" options. These options are the two basic requirements to run SSMS on your computer. You can also check other options, if you want to install them on your local computer. Click the "Next" button.

4

Review the options you selected in the final window. Click the "Next" button and the software installs on your computer. After the software installs, reboot your computer.

5

Click the Windows "Start" button after your computer reboots. Click "All Programs", then click "Microsoft SQL Server," then click "SQL Server Management Studio" to open the software.