我想向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.
更多推荐
我无法更改SQL Server的默认端口(1433)
发布评论