Skip to content

sql-server-configuration-manager-help.md

Latest commit

 

History

History
74 lines (51 loc) · 5.19 KB

sql-server-configuration-manager-help.md

File metadata and controls

74 lines (51 loc) · 5.19 KB
title SQL Server Configuration Manager Help | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
SQL Server Configuration Manager, help
ms.assetid 6e909911-39a6-469b-b22a-3afdfd08a30b
caps.latest.revision 28
author BYHAM
ms.author rickbyh
manager jhubbard

SQL Server Configuration Manager Help

Use [!INCLUDEssNoVersion] Configuration Manager to configure [!INCLUDEssNoVersion] services and configure network connectivity. To create or manage database objects, configure security, and write [!INCLUDEtsql] queries, use [!INCLUDEssManStudioFull]. For more information about [!INCLUDEssManStudioFull], see [!INCLUDEssNoVersion] Books Online.

This section contains the F1 Help topics for the dialogs in [!INCLUDEssNoVersion] Configuration Manager.

Note

[!INCLUDEssNoVersion] Configuration Manager cannot configure versions of [!INCLUDEssNoVersion] earlier than [!INCLUDEmsCoName][!INCLUDEssVersion2005].

Services

[!INCLUDEssNoVersion] Configuration Manager manages services that are related to [!INCLUDEssNoVersion]. Although many of these tasks can be accomplished using the [!INCLUDEmsCoName] Windows Services dialog, is important to note that [!INCLUDEssNoVersion] Configuration Manager performs additional operations on the services it manages, such as applying the correct permissions when the service account is changed. Using the normal Windows Services dialog to configure any of the [!INCLUDEssNoVersion] services might cause the service to malfunction.

Use [!INCLUDEssNoVersion] Configuration Manager for the following tasks for services:

  • Start, stop, and pause services

  • Configure services to start automatically or manually, disable the services, or change other service settings

  • Change the passwords for the accounts used by the [!INCLUDEssNoVersion] services

  • Start [!INCLUDEssNoVersion] using trace flags (command line parameters)

  • View the properties of services

SQL Server Network Configuration

Use [!INCLUDEssNoVersion] Configuration Manager for the following tasks related to the [!INCLUDEssNoVersion] services on this computer:

  • Enable or disable a [!INCLUDEssNoVersion] network protocol

  • Configure a [!INCLUDEssNoVersion] network protocol

Note

For a short tutorial about how to configure protocols and connect to the [!INCLUDEssDEnoversion], see Tutorial: Getting Started with the Database Engine.

SQL Server Native Client Configuration

[!INCLUDEssNoVersion] clients connect to [!INCLUDEssNoVersion] by using the [!INCLUDEssNoVersion] Native Client network library. Use [!INCLUDEssNoVersion] Configuration Manager for the following tasks related to client applications on this computer:

  • For [!INCLUDEssNoVersion] client applications on this computer, specify the protocol order, when connecting to instances of [!INCLUDEssNoVersion].

  • Configure client connection protocols.

  • For [!INCLUDEssNoVersion] client applications, create aliases for instances of [!INCLUDEssNoVersion], so that clients can connect using a custom connection string.

For more information about each of these tasks, see F1 help for each task.

To open SQL Server Configuration Manager

  • On the Start menu, point to All Programs, point to Microsoft SQL Server (version), point to Configuration Tools, and then click SQL Server Configuration Manager.

See Also

SQL Server Services
SQL Server Network Configuration
SQL Native Client 11.0 Configuration
Choosing a Network Protocol