在SQL Server Browser列表框中包含AlwaysOn Listeners

问题描述

我正在使用SmoApplication.EnumAvailableSqlServers类/方法枚举网络上的SQL Server，以允许我的用户从网络上可用服务器列表中选择一个SQL Server。

我的问题是AlwaysOn可用性组（听众）未包含在此列表中。 我理解EnumAvailableSqlServers方法很难找到它们（AO监听器有非标准端口号），但除了让用户手动输入所有内容之外还有其他任何替代方案（非常容易出错）有点，比方说，用户好战）？

任何想法？

谢谢，b $ b Rob

---

谢谢，Rob Hutchison

解决方案

I am using the SmoApplication.EnumAvailableSqlServers class/method to enumerate SQL Servers on my network to allow my users to select a SQL Server from a list of the available servers on the network.

My issue is that AlwaysOn Availability Groups (listeners) are not included in this list.  I understand how it would be difficult for the EnumAvailableSqlServers method to find them (AO listeners have non-standard port numbers), but are there any alternatives other than having users type in everything by hand (very error-prone and is a bit, let's say, user-belligerent)?

Any ideas?

Thanks,
Rob

---

thanks, Rob Hutchison

解决方案

这篇关于在SQL Server Browser列表框中包含AlwaysOn Listeners的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！