This documentation is archived and is not being maintained.

Connecting with Management Studio

New: 5 December 2005

It is easy to connect to the Database Engine from tools that are running on the same computer if you know the name of the instance, and if you are connecting as a member of the Administrators group on the computer. The following procedures must be performed on the same computer that hosts SQL Server.

  1. Log into Windows as a member of the Administrators group, and open either Management Studio or Management Studio Express Edition.

  2. In the Connect to Server dialog box, click Cancel.

  3. If Registered Servers is not displayed, on the View menu, click Registered Servers.

  4. With Database Engine selected on the Registered Servers toolbar, right-click the Database Engine node in the tree, and then click Update Local Server Registration. All instances of the Database Engine installed on the computer are displayed. This includes instances of SQL Server 2000. Management Studio can connect and manage instances of SQL Server 2000 and also SQL Server 2005. The default instance is unnamed and is shown as the computer name. A named instance displays as the computer name followed by a backward slash (\) and then the name of the instance. For SQL Server 2005 Express Edition, the instance is named <computer_name>\sqlexpress unless the name was changed during setup.

  1. In Registered Servers, if the name of your instance of SQL Server has a green dot with a white arrow next to the name, the Database Engine is running and no further action is necessary.

  2. If the name of your instance of SQL Server has a red dot with a white square next to the name, the Database Engine is stopped. Right-click the name of the Database Engine, and then click Start. After a confirmation dialog box, the Database Engine should start and the circle should turn green.

  1. On the File menu, click Connect Object Explorer.

    The Connect to Server dialog box opens. The Server type box displays the type that was last used.

  2. Select Database Engine.

  3. In the Server name box, type the name of the instance of the Database Engine.

  4. Click Connect.

Release History

5 December 2005

New content:
  • This is a new tutorial.
Show: