Muokkaa

Jaa


SQL Server Configuration Manager help

Applies to: SQL Server - Windows only

Use SQL Server Configuration Manager to configure SQL Server services and configure network connectivity. To create or manage database objects, configure security, and write Transact-SQL queries, use SQL Server Management Studio. For more information about SQL Server Management Studio, see SQL Server Books Online.

Tip

If you need to configure SQL Server 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 SQL Server Configuration Manager.

Note

SQL Server Configuration Manager can't configure versions of SQL Server earlier than SQL Server 2005 (9.x).

Services

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

Use SQL Server 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 SQL Server services
  • Start SQL Server using trace flags (command line parameters)
  • View the properties of services

SQL Server network configuration

Use SQL Server Configuration Manager for the following tasks related to the SQL Server services on this computer:

  • Enable or disable a SQL Server network protocol
  • Configure a SQL Server network protocol

Note

For a short tutorial about how to configure protocols and connect to the SQL Server Database Engine, see Tutorial: Getting Started with the Database Engine.

SQL Server Native Client configuration

Important

SQL Server Native Client (SNAC) isn't shipped with:

  • SQL Server 2022 (16.x) and later versions
  • SQL Server Management Studio 19 and later versions

The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) aren't recommended for new application development.

For new projects, use one of the following drivers:

For SQLNCLI that ships as a component of SQL Server Database Engine (versions 2012 through 2019), see this Support Lifecycle exception.

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

  • For SQL Server client applications on this computer, specify the protocol order, when connecting to instances of SQL Server.

  • Configure client connection protocols.

  • For SQL Server client applications, create aliases for instances of SQL Server, 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 Microsoft 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 SQL Server 2022 (16.x)). For other versions of SQL Server, 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.