How to Know all Sql Servers instances on a LAN

  • Hi, how can I know how many and which server or pc's has installed Sql server and what version.

    With OSQL -L only display instance name but not server name and user.

    Thanks for any advice.

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

    I've used the SQLRecon tool there in the past with some good results. As I recall it lists version information.

  • Yes, SQL Recon is the best tool out there. It'll use all known methods to detect SQL Server. Which means... get a domain admin to run it for you because they should have rights to all the systems to investigate the registry and services.

     

    K. Brian Kelley
    @kbriankelley

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply