Skip to content

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

Latest commit

 

History

History
59 lines (40 loc) · 3.53 KB

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

File metadata and controls

59 lines (40 loc) · 3.53 KB
title Administer Servers with SQL Server Management Studio
ms.custom seo-lt-2019
ms.date 01/19/2017
ms.prod sql
ms.prod_service sql-tools
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 markingmyname
ms.author maghan

Administer Servers with SQL Server Management Studio

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] [!INCLUDEmsCoName] [!INCLUDEssManStudioFull] is a rich, integrated administrative client designed to meet the [!INCLUDEssNoVersion] and Azure SQL Database 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], [!INCLUDEssRSnoversion], [!INCLUDEssISnoversion] or Azure SQL Database.

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 How to: Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager).

Use [!INCLUDEssManStudio] to:

  • Register servers.

  • Connect to an instance of the [!INCLUDEssDE], SSAS, [!INCLUDEssRS], [!INCLUDEssIS] or Azure SQL Database.

  • Configure server properties.

  • Manage database and SSAS 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
How to: View server properties (SQL Server Management Studio)