Skip to content

Latest commit

 

History

History
85 lines (58 loc) · 6.52 KB

sql-server-configuration-manager-help.md

File metadata and controls

85 lines (58 loc) · 6.52 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.collection helpviewer_keywords monikerRange
SQL Server Configuration Manager Help
Get acquainted with SQL Server Configuration Manager. Learn how to use it to manage SQL Server services and configure network connectivity.
rwestMSFT
randolphwest
randolphwest
07/26/2024
sql
tools-other
conceptual
data-tools
SQL Server Configuration Manager, help
>=sql-server-2016

SQL Server Configuration Manager help

[!INCLUDE SQL Server Windows Only]

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

Tip

If you need to configure [!INCLUDE ssNoVersion] on Linux, use the mssql-conf tool. For more information, see Configure SQL Server on Linux with the mssql-conf tool.

This section contains the F1 Help articles for the dialogs in [!INCLUDE ssNoVersion] Configuration Manager.

Note

[!INCLUDE ssNoVersion] Configuration Manager can't configure versions of [!INCLUDE ssNoVersion] earlier than [!INCLUDE ssVersion2005].

Services

[!INCLUDE ssNoVersion] Configuration Manager manages services that are related to [!INCLUDE ssNoVersion]. Although many of these tasks can be accomplished using the Windows Services dialog, is important to note that [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion] services might cause the service to malfunction.

Use [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion] services
  • Start [!INCLUDE ssNoVersion] using trace flags (command line parameters)
  • View the properties of services

SQL Server network configuration

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

  • Enable or disable a [!INCLUDE ssNoVersion] network protocol
  • Configure a [!INCLUDE ssNoVersion] network protocol

Note

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

SQL Server Native Client configuration

Important

[!INCLUDE snac-removed-oledb-and-odbc]

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

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

  • Configure client connection protocols.

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

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

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 select SQL Server Configuration Manager.

Because SQL Server Configuration Manager is a snap-in for the [!INCLUDE msconame-md] Management Console program and not a stand-alone program, SQL Server Configuration Manager doesn't appear as an application in newer versions of Windows.

Operating system Details
Windows 10 and Windows 11 To open SQL Server Configuration Manager, on the Start Page, type SQLServerManager16.msc (for [!INCLUDE sssql22-md]). For other versions of [!INCLUDE ssNoVersion], replace 16 with the appropriate number. Selecting SQLServerManager16.msc opens the Configuration Manager. To pin the Configuration Manager to the Start Page or Task Bar, right-click SQLServerManager16.msc, and then select Open file location. In the Windows File Explorer, right-click SQLServerManager16.msc, and then select Pin to Start or Pin to taskbar.
Windows 8 To open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager<version>.msc, such as SQLServerManager16.msc, and then press Enter.

Related content