SQL Server网络配置

最新推荐文章于 2025-03-05 00:50:59 发布

culuo4781

最新推荐文章于 2025-03-05 00:50:59 发布

阅读量2.7k

点赞数

文章标签：网络 java linux python 数据库

原文链接：https://www.sqlshack.com/sql-server-network-configuration/

版权

SQL Server网络配置涉及启用管理与SQL Server连接的协议，并配置安全和隐藏实例等选项。主要协议包括共享内存、TCP/IP和命名管道。启用或禁用协议需要重启服务，TCP/IP协议最常用，可通过配置特定端口加强安全性。强制加密可加密通信，隐藏实例则避免通过浏览发现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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共享内存协议是最简单的协议，因为它没有要使用的可调整设置。如果这些协议配置不正确，则可以使用“共享内存”协议对其他网络协议进行故障排除。