我无法更改SQL Server的默认端口(1433)

本文介绍了我无法更改SQL Server的默认端口(1433)的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我想向SQL Server的默认1433端口添加另一个端口.因此，我打开了配置管理器，选择了Protocols for MSSQLSERVER，然后双击TCP/IP以查看其属性.然后，选择IP Addresses选项卡，然后向下滚动到IPAll部分.然后将1433更改为1433,1450，以便也可以使用1450端口连接到服务器.问题是此更改需要重新启动sql server服务，并且由于以下错误，我在停止服务器后无法启动服务器:

I want to add another port to default 1433 port of sql server. So I opened the configuration manager, selected Protocols for MSSQLSERVER and then double clicked on TCP/IP to see its properties. Then I selected the IP Addresses tab and scrolled down right to the IPAll section. and then I change 1433 to 1433,1450 so that I could also connect to the server using 1450 port. The problem is this change requires to restart sql server service and I cannot start the server after stopping it because of the following error:

The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.

我在事件日志中看到以下错误:

I see the following error in event log:

SQL Server could not spawn FRunCM thread.

如果我从tcp端口中删除了1450，则sql server将能够再次运行而没有任何问题.

If I remove 1450 from tcp ports, sql server will be able to run again without any problem.

我之前已经做过，但是我不明白为什么我不能在这台服务器上做到这一点.

I have done this before but I don't understand why I cannot do it on this server.

推荐答案

您首先需要在服务器中添加新的TDS终结点，请参见如何:配置数据库引擎以侦听多个TCP端口:

You need to add a new TDS endpoint in the server first, see How to: Configure the Database Engine to Listen on Multiple TCP Ports:

CREATE ENDPOINT [CustomConnection] STATE = STARTED AS TCP (LISTENER_PORT = 1450, LISTENER_IP =ALL) FOR TSQL() ; GO

然后将引擎配置为在执行此操作时在两个端口上进行侦听.确保选择一个免费端口，并确保防火墙允许该端口.

then configure the engine to listen on both ports, as you're doing. Make sure you choose a free port and make sure the port is allowed in Firewall.

添加多个侦听端口的通常原因是将客户端关联到NUMA或soft-NUMA，请参见如何:将TCP/IP端口映射到NUMA节点和如何:将SQL Server配置为使用Soft-NUMA .

The usual reason to add multiple listening ports is to affinitize clients to NUMA or soft-NUMA, see How to: Map TCP/IP Ports to NUMA Nodes and How to: Configure SQL Server to Use Soft-NUMA.