SQL Server 2008 中的静态端口分配不保存
我有两个 SQL Server 2008 命名实例，并尝试为每个实例设置静态端口。 我打开SQL Server配置管理器_> 展开“SQL Server 网络配置”-> 点击我要更改的实例-> 并选择 TCP/IP。
从这里开始，我所做的任何配置更改在单击“确定”后都不会保留。 我尝试将“TCP 动态端口”选项设置为空白，并在 IPALL 部分下的“TCP 端口”选项下设置所需的端口号，但每次返回配置屏幕时，更改不再出现。
我已经尝试过取消该服务，但这也没有帮助。
有人对这里发生的事情有任何想法吗？
I have two named instances of SQL Server 2008 and am trying to set static ports for each instance. I open the SQL Server Configuration Manager _> expand "SQL Server Network Configuration" -> click the instance I want to change -> and select TCP/IP.
From here any configuration changes that I make are not persisted after I hit OK. I've tried setting the "TCP Dynamic Ports" option to blank, and setting my desired port # under the "TCP Port" option under the IPALL section but each time when I return to the configuration screen the changes no longer appear.
I've tried bouncing the service and that doesn't help either.
Does anyone have any thoughts as to what is going on here?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
事实证明，问题是我的帐户不是计算机上的本地管理员。 我是 SQL Server 的系统管理员，所以我认为它可以工作。
令人沮丧的是，界面没有提醒我我没有权限，它只是告诉我我的更改已保存并继续忽略它们。
感谢所有回答的人！
Turns out the problem was that my account wasn't a local admin on the machine. I'm a sysadmin on the SQL Server so I assumed it would work.
The frustrating thing is that the interface didn't alert me that i didn't have permissions it simply told me that my changes were saved and proceeded to ignore them.
thanks to all those who answered though!
更改后是否重新启动 SQL Server？
Did you restart the SQL Server after you made the change?
您是否更改特定 NIC 下或 IPAll 部分下的 TCP 端口？
您应该在 IPAll 下（在最底部）执行此操作。
Are you changing the TCP Port under a specific NIC or under the IPAll section?
You should be doing it under the IPAll (at the very bottom).