具有不同端口AlwaysOn 2016的多实例 [英] Multi Instance with different port AlwaysOn 2016
问题描述
大家好,
我正在使用SQL 2016 Enterprise配置多实例Always On Availability组。
我有两个服务器DB-01和DB-02
我在默认实例中使用DAG成功配置了AlwaysOn。一切正常。 WSFC工作得很好。完美。
我在安装第二个实例时遇到大问题,例如"INSTANCEONE"在两台服务器上。
第二个实例必须在不同的tcp端口上运行,例如1435.使用向导配置可用性组时,我可以在经典登录屏幕上指定tcp端口(参见图像)虽然只能进行故障转移,但AG无法连接这两个实例,因为
尝试连接默认端口。
我的问题是:
1)是否存在配置多实例AlwaysOn集群的方法?
2)如何编辑副本实例配置以使用非默认tcp端口?
谢谢!!
这是当我执行手动故障转移时,我无法更改连接设置,包括tcp端口。它是灰色的
Hi all,
I'm configuring a multi instance Always On Availability group with SQL 2016 Enterprise.
I have two server DB-01 and DB-02
I successfully configure AlwaysOn with DAG in default Instance. All works Fine. WSFC works Fine. Perfect.
I have a Big problem installing a second Instance called for example "INSTANCEONE" on both servers.
The second Instance must run on a different tcp port, example 1435. When configuring a Availability Group with wizard i can specify tcp port on the classic login screen (see image) but whet permorm a failover, the AG cannot connect both instances because try to connect with default port.
My questions are:
1) exist a way to configure multi instance AlwaysOn cluster?
2) how can edit the Replica instance configuration to use non default tcp ports?
Thank you !!
This is the situation when i performing manual failover, i cannot change the connection settings including the tcp port. Its greyed out
这篇关于具有不同端口AlwaysOn 2016的多实例的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!