在局域网上的特定计算机上查找SQLServer实例 [英] Find SQLServer Instance on an specific computer on LAN

问题描述

亲爱的朋友，

我具有以下功能来查找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

推荐答案

使用 http://msdn.microsoft .com/en-us/library/system.data.sql.sqldatasourceenumerator.instance(v = vs.80).aspx [在本地网络上定位SQL Server实例 [

Use New ManagedComputer(machineName)[^]

OR

Try SqlDataSourceEnumerator.Instance.GetDataSources
Ref:http://msdn.microsoft.com/en-us/library/system.data.sql.sqldatasourceenumerator.instance(v=vs.80).aspx[^]

Or

Locate SQL Server instances on the local network[^]

这篇关于在局域网上的特定计算机上查找SQLServer实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！