在SQL Server Browser列表框中包含AlwaysOn Listeners [英] Including AlwaysOn Listeners in a SQL Server Browser list box

问题描述

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

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

任何想法？

谢谢，b $ b Rob

---

谢谢，Rob Hutchison

解决方案

你好Rob，

喜欢这个文档：

https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.smoapplication.enumavailablesqlservers.aspx?f= 255& MSPPError = -2147217396

为了清楚地解决这个问题，这个问题是否与SQL Server有关？

实际上这个论坛将讨论：

Visual Studio WPF / SL Designer，Visual Studio Guidance Automation Toolkit，开发人员文档和帮助系统以及Visual Studio编辑器。

很抱歉，我没有找到与VS相关的信息，所以如果你可以分享我们关于这个问题的更多信息会更好，但如果是SQL Server问题，请在此处选择论坛：

https ：//social.msdn.microsoft.com/Forums/sqlserver/en-US/home？category = sqlserver

最好的问候，

杰克

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

解决方案

Hi Rob,

Like this document:

https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.smoapplication.enumavailablesqlservers.aspx?f=255&MSPPError=-2147217396

Just to make this issue clearly, whether this issue is related to the SQL Server?

Actually this forum is to discuss:

Visual Studio WPF/SL Designer, Visual Studio Guidance Automation Toolkit, Developer Documentation and Help System, and Visual Studio Editor.

Sorry for that I didn't find the information which is related to the VS, so it would be better if you could share us more information about this issue, but if it is the SQL Server issue, please select the forum here:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

Best Regards,

Jack

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