Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Finding SQL Servers

Author  Topic 

youruseridistoxic
Yak Posting Veteran

65 Posts

Posted - 2008-07-16 : 10:37:55
Running OSQL -L is great, but what about sql servers with the browsing service disabled?

Does anyone have any tips for finding these (hidden) servers?

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-07-16 : 11:18:46
You can use the free SQLPing 3.0 utility available on the link below to find SQL Server instances on an entire IP subnet. It uses multiple methods to discover them, and can often find instances where SQL Server is not started.

http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx


CODO ERGO SUM
Go to Top of Page
   

- Advertisement -