我无法更改SQL Server的默认端口(1433) [英] I cannot change sql server's default port (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.
推荐答案
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节点和
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.
这篇关于我无法更改SQL Server的默认端口(1433)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!