SQL Server网络配置

SQL Server Network Configuration involves enabling the protocols that manage the connection to the SQL Server and configuring the available options for these network protocols. It also provides the means to encrypt the communication between the SQL Server instance and the client applications and hide the SQL Server instance from being browsed. SQL Server Network Configuration can be managed using the SQL Server Configuration Manager tool.

SQL Server网络配置包括启用用于管理与SQL Server的连接的协议以及为这些网络协议配置可用选项。 它还提供了加密SQL Server实例与客户端应用程序之间的通信并隐藏SQL Server实例以免其被浏览的方法。 可以使用SQL Server配置管理器工具来管理SQL Server网络配置。

There are three main network protocols that you can configure in SQL Server. All these network protocols are installed by default when installing the SQL Server instance, but you need to enable one or more network protocols that the clients will use to communicate with the SQL Server.

您可以在SQL Server中配置三种主要的网络协议。 在安装SQL Server实例时，默认情况下会安装所有这些网络协议，但是您需要启用一个或多个客户端将用于与SQL Server通信的网络协议。

To enable or disable a specific network protocol, open the SQL Server Configuration Manager and expand the SQL Server Network Configuration node to view the Protocols for <instance name>. At the details area in the right, right-click on the protocol you are interested in and click on Enable or Disable as below:

若要启用或禁用特定的网络协议，请打开SQL Server配置管理器，然后展开“ SQL Server网络配置”节点以查看<instance name>的协议 。 在右侧的详细信息区域，右键单击所需的协议，然后单击启用或禁用 ，如下所示：

Enabling or disabling the SQL Server network protocols requires restarting the SQL Server service to take effect, which can be done from the same console. From the SQL Server Configuration Manager, click on the SQL Server Services. From the details area in the right, right-click on the SQL Server (<instance name>) service for the configured SQL Server instance and choose Restart.

启用或禁用SQL Server网络协议需要重新启动SQL Server服务才能生效，这可以在同一控制台中完成。 在SQL Server配置管理器中 ，单击“ SQL Server服务” 。 在右侧的详细信息区域中，右键单击已配置SQL Server实例的SQL Server（<实例名称>）服务，然后选择Restart 。

共享内存协议 (Shared Memory Protocol)

SQL Server Shared Memory protocol is used by clients to connect to the SQL Server instance that is running on the same machine. SQL Server Shared Memory protocol is the simplest protocol, as it has no configurable settings to be tuned in order to use it. Shared Memory protocol can be used to troubleshoot other network protocols if these protocols are not configured correctly.

客户端使用SQL Server共享内存协议连接到同一台计算机上运行SQL Server实例。 SQL Server共享内存协议是最简单的协议，因为它没有要使用的可调整设置。 如果这些协议配置不正确，则可以使用“共享内存”协议对其他网络协议进行故障排除。

TCP / IP协议 (TCP/IP Protocol)

The most commonly used network protocol in SQL Server is the TCP/IP protocol. This protocol connects computers wit