如何使用ip地址获取所有sql server实例 [英] How to get all sql server instances using ip address

问题描述

当我输入ip地址时，我想在组合框中获取所有sql server实例名称

Hi,i want to get all sql server instances name in combobox when i enter ip address

推荐答案

有几种方法可以获取信息.. 。例如

已安装的SQL Server实例列表 [ ^ ] - 您可能需要做进一步的研究on OpenRemoteBaseKey



或



http://www.mssqltips.com/sqlservertip / 2013 / find-sql-server-instances-across-your-network-using-windows-powershell / [ ^ ]



或（这个就在这里CodeProject）



如何在网络中枚举SQL Server实例 [ ^ ]

There are a few ways you can get the information ... e.g.
List of installed SQL Server instances[^] - you may need to do additional research on OpenRemoteBaseKey

or

http://www.mssqltips.com/sqlservertip/2013/find-sql-server-instances-across-your-network-using-windows-powershell/[^]

or (and this one is right here on CodeProject)

How to enum SQL Server instances in network[^]

这篇关于如何使用ip地址获取所有sql server实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！