Skip to content

lesson-1-1-start-sql-server-management-studio.md

Latest commit

 

History

History
48 lines (32 loc) · 3.8 KB

lesson-1-1-start-sql-server-management-studio.md

File metadata and controls

48 lines (32 loc) · 3.8 KB
title Start SQL Server Management Studio | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology ssms
ms.topic conceptual
ms.assetid 25ffaea6-0eee-4169-8dd0-1da417c28fc6
author stevestein
ms.author sstein
manager craigg

Start SQL Server Management Studio

To begin this tutorial, let's take a look at [!INCLUDEssManStudioFull].

Opening SQL Server Management Studio

To open SQL Server Management Studio

  1. On the Start menu, point to All Programs, point to [!INCLUDEssCurrentUI], and then click SQL Server Management Studio.

    [!NOTE]
    [!INCLUDEssManStudioFull] is not installed by default. If [!INCLUDEssManStudio] is unavailable, install it by running Setup. [!INCLUDEssManStudio] is not available with [!INCLUDEssExpress]. [!INCLUDEssManStudio] Express is available as a free download from the Microsoft Download Center, but has a different user interface than is described in this tutorial.

  2. In the Connect to Server dialog box, verify the default settings, and then click Connect. To connect, the Server name box must contain the name of the computer where [!INCLUDEssNoVersion] is installed. If the [!INCLUDEssDE] is a named instance, the Server name box should also contain the instance name in the format <computer_name>\<instance_name>.

Management Studio Components

[!INCLUDEssManStudio] presents information in windows dedicated to specific types of information. Database information is shown in Object Explorer and document windows.

  • Object Explorer is a tree view of all the database objects in a server. This can include the databases of the [!INCLUDEssDEnoversion], [!INCLUDEssASnoversion], [!INCLUDEssRSnoversion], and [!INCLUDEssISnoversion]. Object Explorer includes information for all servers to which it is connected. When you open [!INCLUDEssManStudio], you are prompted to connect Object Explorer to the settings that were last used. You can double-click any server in the Registered Servers component to connect to it, but you do not have to register a server to connect.

  • The document window is the largest portion of [!INCLUDEssManStudio]. The document windows can contain query editors and browser windows. By default, the Summary page is displayed, connected to the instance of [!INCLUDEssDE] on the current computer.

Showing Additional Windows

To show the Registered Servers window

  1. On the View menu, click Registered Servers.

    The Registered Servers window appears above Object Explorer. Registered Servers lists servers which you manage frequently. You can add and remove servers from this list. The only servers listed are the [!INCLUDEssNoVersion] instances on the computer where you are running [!INCLUDEssManStudio].

  2. If your server does not appear, in Registered Servers, right-click Database Engine, and then click Update Local Server Registration.

Next Task in Lesson

Connect with Registered Servers and Object Explorer