在局域网上的特定计算机上查找SQLServer实例

本文介绍了在局域网上的特定计算机上查找SQLServer实例的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

亲爱的朋友， 我具有以下功能来查找SQLServer实例.它可以在本地计算机上正常工作.您能否告诉我如何使用此功能来检查局域网中其他计算机上的实例?我正在使用VS2008(框架3.5)和SQL Server Express2005.

Dear friend, I am having the following function to find a SQLServer instance. It works fine on local computer. Would you please tell me how to use this function to check an Instance on other computer on a Local Area Network? I am using VS2008 (framework 3.5) and SQL Server Express 2005.

Private Function MyInstanceFound(ByVal MyInstanceName As String) As Boolean Dim InstanceFound As Boolean = False Dim MC As ManagedComputer = New ManagedComputer() For Each SI As ServerInstance In MC.ServerInstances If SI.Name.ToString = MyInstanceName Then InstanceFound = True Exit For End If Next Return InstanceFound End Function

提前谢谢您. 问候， SKPaul

Thanking you in advance. Regards, SKPaul

推荐答案

使用新的ManagedComputer(machineName) [ ^ ] 或 尝试SqlDataSourceEnumerator.Instance.GetDataSources 参考: msdn.microsoft /en-us/library/system.data.sql.sqldatasourceenumerator.instance(v = vs.80).aspx [ ^ ] 或 在本地网络上定位SQL Server实例 [ ^ ] Use New ManagedComputer(machineName)[^] OR Try SqlDataSourceEnumerator.Instance.GetDataSources Ref:msdn.microsoft/en-us/library/system.data.sql.sqldatasourceenumerator.instance(v=vs.80).aspx[^] Or Locate SQL Server instances on the local network[^]