要如何查詢区网内有多少SQL SERVER存在呢

Question

要如何查詢区网内有多少SQL SERVER存在呢，然后尝试连接选中的server

Answer 1

参考:

Find all instances of sql server programmatically

Answer 2

你好，GodG

The link provided by Simon Cai above is very exciting and you’d better have a try. Besides, you could have a look at the following article which provides another idea to get the SQL Server list by sending out a Broadcast UDP packet on port 1434, with the contents of just a byte of 0x02, to which each server would respond. Or, you could try to use the SmoApplication.EnumAvailableSqlServers to achieve your need.

http://www.codeproject.com/Articles/12336/Locate-SQL-Server-instances-on-the-local-network

Best Regards,

Albert Zhang