Vishal Pandey

Vishal Pandey

  • NA
  • 19
  • 23.5k

Find Local SQL Servers when Off Network

Feb 8 2006 11:09 PM
We use SQLDMO.Application.ListAvailableSQLServers to show a list of all visible SQL Servers. This works great, until the user disconnects his network cable. Now I'd expect to lose the servers on other computers, but we also can't see the servers running on the local box.

After some googling, I'm aware that this is a known issue with ListAvailableSQLServers. Fine. However, if I use Enterprise Manager on the disconnected box, it can see the local instances just fine.

So, anybody here know the magic API call or other technique for listing the SQL Servers on the local box when the network is disconnected?