Skip to content

administer-servers-with-sql-server-management-studio.md

Latest commit

 

History

History
59 lines (39 loc) · 3.46 KB

administer-servers-with-sql-server-management-studio.md

File metadata and controls

59 lines (39 loc) · 3.46 KB
title Administer Servers with 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
helpviewer_keywords
SQL Server Management Studio [SQL Server], servers
servers [SQL Server], administering
ms.assetid 938bb035-e07a-4082-9f93-229d9feb6b06
author stevestein
ms.author sstein
manager craigg

Administer Servers with SQL Server Management Studio

[!INCLUDEmsCoName] [!INCLUDEssManStudioFull] is a rich, integrated administrative client designed to meet the [!INCLUDEssNoVersion] administrator's server management requirements. In [!INCLUDEssManStudio], administrative tasks are accomplished using Object Explorer, which allows you to connect to any server in the [!INCLUDEssNoVersion] family and graphically browse its contents. A server can be an instance of the [!INCLUDEssDE], [!INCLUDEssASnoversion], or [!INCLUDEssRSnoversion], [!INCLUDEssISnoversion].

The tool components of [!INCLUDEssManStudio] include Registered Servers, Object Explorer, Solution Explorer, Template Explorer, the Object Explorer Details page, and the document window. To display a tool, on the View menu, click the tool name. To display the Query Editor tool, click the New Query button on the toolbar.

Important

Network traffic between [!INCLUDEssManStudio] and [!INCLUDEssNoVersion] is unencrypted by default. Do not work with sensitive data (including passwords) in [!INCLUDEssManStudio] unless you have established an encrypted connection. For more information, see Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager).

Use [!INCLUDEssManStudio] to:

  • Register servers.

  • Connect to an instance of the [!INCLUDEssDE], [!INCLUDEssAS], [!INCLUDEssRS], or [!INCLUDEssIS].

  • Configure server properties.

  • Manage database and [!INCLUDEssAS] objects such as cubes, dimensions, and assemblies.

  • Create objects, such as databases, tables, cubes, database users, and logins.

  • Manage files and filegroups.

  • Attach or detach databases.

  • Launch scripting tools.

  • Manage security.

  • View system logs.

  • Monitor current activity.

  • Configure replication.

  • Manage full-text indexes.

To start and stop [!INCLUDEssNoVersion] or [!INCLUDEssNoVersion] Agent, use [!INCLUDEssNoVersion] Configuration Manager.

See Also

Use SQL Server Management Studio
View or Change Server Properties (SQL Server)