作者:手机用户2502931713 | 来源:互联网 | 2023-10-10 10:51
1.使用图形工具进行修改 在主节点登录登录SQLServerManagementStudio----对象资源管理器(objectexplorer)----AlwaysON高可用
1.使用图形工具进行修改
在主节点登录
登录SQL Server Management Studio
---->对象资源管理器(object explorer)
---->AlwaysON高可用性组(always on high availability)
---->可用性组(Availability Groups)
---->可用性组侦听器(Availability group Listeners)
---->右击已有的监听器
---->点击属性(Properties)
---->编辑port
---->确定(ok)
2.使用命令修改
(1).修改端口
alter endpoint []
state = started
as tcp (listener_port = 1233, listener_ip = (10.x.x.x))
for data_mirroring (role = all, authentication = windows negotiate, encryption = required algorithm aes)
go
简单点可以这样:
alter endpoint []
state = started
as tcp (listener_port = 1233)
go
(2).修改复制URL
alter availability group []
modify replica on 'mynode1' with (endpoint_url = 'tcp://mynode1.mydomain.com:1233')
go