如何使用mysql配置管理器_SQL Server 配置管理器帮助

SQL Server 配置管理器帮助SQL Server Configuration Manager Help

02/01/2018

本文内容

适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions) - 仅限 Windows Azure SQL 托管实例Azure SQL Managed InstanceAzure SQL 托管实例Azure SQL Managed Instance适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions) - Windows only Azure SQL 托管实例Azure SQL Managed InstanceAzure SQL 托管实例Azure SQL Managed Instance

使用 SQL ServerSQL Server 配置管理器可以配置 SQL ServerSQL Server 服务和网络连接。Use SQL ServerSQL Server Configuration Manager to configure SQL ServerSQL Server services and configure network connectivity. 若要创建或管理数据库对象、配置安全性以及编写 Transact-SQLTransact-SQL 查询，请使用 SQL Server Management StudioSQL Server Management Studio。To create or manage database objects, configure security, and write Transact-SQLTransact-SQL queries, use SQL Server Management StudioSQL Server Management Studio. 有关 SQL Server Management StudioSQL Server Management Studio的详细信息，请参阅 SQL ServerSQL Server 联机丛书。For more information about SQL Server Management StudioSQL Server Management Studio, see SQL ServerSQL Server Books Online.

提示

如果需要在 Linux 上配置 SQL ServerSQL Server，请使用 mssql-conf 工具。If you need to configure SQL ServerSQL Server on Linux, use the mssql-conf tool.

本节包含了按 F1 后看到的有关 SQL ServerSQL Server 配置管理器中各对话框的帮助主题。This section contains the F1 Help topics for the dialogs in SQL ServerSQL Server Configuration Manager.

备注

SQL ServerSQL Server 配置管理器无法配置 MicrosoftMicrosoftSQL Server 2005 (9.x)SQL Server 2005 (9.x) 之前的 SQL ServerSQL Server 版本。Configuration Manager cannot configure versions of SQL ServerSQL Server earlier than MicrosoftMicrosoftSQL Server 2005 (9.x)SQL Server 2005 (9.x).

服务Services

SQL ServerSQL Server 配置管理器管理与 SQL ServerSQL Server相关的服务。Configuration Manager manages services that are related to SQL ServerSQL Server. 尽管其中许多任务可以使用 MicrosoftMicrosoft Windows 服务对话框来完成，但值得注意的是 SQL ServerSQL Server 配置管理器还可以对其管理的服务执行更多的操作(例如，在服务帐户更改后应用正确的权限)。Although many of these tasks can be accomplished using the MicrosoftMicrosoft Windows Services dialog, is important to note that SQL ServerSQL Server Configuration Manager performs additional operations on the services it manages, such as applying the correct permissions when the service account is changed. 使用标准的 Windows 服务对话框配置任何 SQL ServerSQL Server 服务都可能会造成服务无法正常工作。Using the normal Windows Services dialog to configure any of the SQL ServerSQL Server services might cause the service to malfunction.

使用 SQL ServerSQL Server 配置管理器可以完成下列服务任务：Use SQL ServerSQL 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

更改 SQL ServerSQL Server 服务所使用的帐户的密码Change the passwords for the accounts used by the SQL ServerSQL Server services

使用跟踪标志(命令行参数)启动 SQL ServerSQL ServerStart SQL ServerSQL Server using trace flags (command line parameters)

查看服务的属性View the properties of services

SQL Server 网络配置SQL Server Network Configuration

使用 SQL ServerSQL Server 配置管理器可以完成下列与此计算机上的 SQL ServerSQL Server 服务相关的任务：Use SQL ServerSQL Server Configuration Manager for the following tasks related to the SQL ServerSQL Server services on this computer:

启用或禁用 SQL ServerSQL Server 网络协议Enable or disable a SQL ServerSQL Server network protocol

配置 SQL ServerSQL Server 网络协议Configure a SQL ServerSQL Server network protocol

备注

有关如何配置协议和连接到 SQL Server 数据库引擎SQL Server Database Engine 的简短教程，请参阅教程：数据库引擎入门。For a short tutorial about how to configure protocols and connect to the SQL Server 数据库引擎SQL Server Database Engine, see Tutorial: Getting Started with the Database Engine.

SQL Server Native Client 配置SQL Server Native Client Configuration

SQL ServerSQL Server 客户端通过使用 SQL ServerSQL Server Native Client 网络库连接到 SQL ServerSQL Server 。clients connect to SQL ServerSQL Server by using the SQL ServerSQL Server Native Client network library. 使用 SQL ServerSQL Server 配置管理器可以完成下列与此计算机上的客户端应用程序相关的任务：Use SQL ServerSQL Server Configuration Manager for the following tasks related to client applications on this computer:

对于此计算机上的 SQL ServerSQL Server 客户端应用程序，指定连接到 SQL ServerSQL Server实例时的协议顺序。For SQL ServerSQL Server client applications on this computer, specify the protocol order, when connecting to instances of SQL ServerSQL Server.

配置客户端连接协议。Configure client connection protocols.

对于 SQL ServerSQL Server 客户端应用程序，创建 SQL ServerSQL Server实例的别名，使客户端能够使用自定义连接字符串进行连接。For SQL ServerSQL Server client applications, create aliases for instances of SQL ServerSQL Server, so that clients can connect using a custom connection string.

有关这些任务的详细信息，请参阅每个任务的 F1 帮助。For more information about each of these tasks, see F1 help for each task.

打开 SQL Server 配置管理器To open SQL Server Configuration Manager

在“开始”菜单上，依次指向“所有程序”、“Microsoft SQL Server”(版本)、“配置工具”，然后单击“SQL Server 配置管理器”。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.

使用 Windows 8Windows 8 访问 SQL ServerSQL Server 配置管理器To access SQL ServerSQL Server Configuration Manager Using Windows 8Windows 8

因为 SQL ServerSQL Server 配置管理器是 MicrosoftMicrosoft 管理控制台程序的一个管理单元而不是单独的程序，所以，当运行 SQL ServerSQL Server 时， Windows 8Windows 8配置管理器不显示为一个应用程序。Because SQL ServerSQL Server Configuration Manager is a snap-in for the MicrosoftMicrosoft Management Console program and not a stand-alone program, SQL ServerSQL Server Configuration Manager not does not appear as an application when running Windows 8Windows 8. 要打开 SQL ServerSQL Server 配置管理器，请在“搜索”超级按钮中的“应用”下，键入 SQLServerManager12.msc(对于 SQL Server 2014 (12.x)SQL Server 2014 (12.x))或 SQLServerManager11.msc(对于 SQL Server 2012 (11.x)SQL Server 2012 (11.x))，然后按 Enter 。To open SQL ServerSQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager12.msc (for SQL Server 2014 (12.x)SQL Server 2014 (12.x)) or SQLServerManager11.msc (for SQL Server 2012 (11.x)SQL Server 2012 (11.x)), and then press Enter.

另请参阅See Also