多个“默认" SQL Server群集中的实例? (又称多个群集实例，无需连接实例名称) [英] Multiple "Default" instances in SQL Server cluster? (AKA multiple clustered instances without requiring an instance name to connect)

问题描述

我正在一个主动/主动群集上以及我们现有的SQL群集上设置多个SQL实例，该群集的名称为SQLCLUSTER，但是我们以SQLCLUSTERINST1 \ Instance1，SQLCLUSTERINST2 \ Instance2等访问这些实例.无论如何都有自己的IP和网络名称，是否可以在每个网络名称上安装SQL作为默认"实例?我真的很想访问我的实例而不必给出实例名称(即，不是上面的实例，只是SQLCLUSTERINST1，SQLCLUSTERINST2等)，但是我对SQL的理解是，即使在集群中，实例名称也是必需的，即使IP已经唯一标识了一个实例.

I'm setting up multiple SQL instances on an active/active cluster, and on our existing SQL Cluster, the cluster name is SQLCLUSTER, but we access the instances as SQLCLUSTERINST1\Instance1, SQLCLUSTERINST2\Instance2, etc. Since each instance has its own IP and network name anyway, can I install SQL as the "Default" instance on each network name? I'd really like to access my instances without having to give the instance name (ie, instead of the above, just SQLCLUSTERINST1, SQLCLUSTERINST2, etc), but my understanding of SQL is that, even in a cluster, the instance name is required, even though the IP already uniquely identifies an instance.

有人知道我能做到吗?我将要安装第一个实例，如果不需要，我想在开始将它们安装为命名实例之前得到一个答案.仅当实例集群名称将按原样唯一标识sql实例时，不得不给出实例集群名称和实例名称以连接到服务器，这似乎是多余的，并且可能是不必要的.我希望每个群集组(因为它们共享一个IP)一个默认实例，而不是每个群集.

Does anybody know if I can do this? I'm about to install the first instance, and I wanted to get an answer to this before I start installing them as named instances if I don't need to. It just seems reduntant, and potentially unnecessary, to have to give the instance cluster name and the instance name to connect to a server when just the instance cluster name would uniquely identify a sql instance as-is. I would expect one default instance per cluster group (as they'd share an IP), but not per cluster.

推荐答案

我最终找到了解决方法.在群集上安装命名实例后，可以使用每个DNS名称上的端口1433访问它们，因此不必提供要连接的实例名称.

I ended up finding a work-around for this. While I installed named instances on the cluster, I can access them using port 1433 on each DNS name, so I don't have to provide the instance name to connect, which is what I was after.

要实现此目的，我必须修改侦听器配置，以强制每个实例侦听其专用IP上的端口1433，而不仅仅是依靠动态端口和SQL Browser.

To get this accomplished, I have to modify the listener configuration to force each instance to listen on port 1433 on its dedicated IP, rather than just relying on dynamic ports and the SQL Browser.

我已经详细说明了步骤

I've detailed the steps on my blog

这篇关于多个“默认" SQL Server群集中的实例? (又称多个群集实例，无需连接实例名称)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！