Post reply

Locating SQL Server Instances on a Network

  • October 5, 2009 at 9:55 am

    #156287

    Hi,

    I am in a need to search for a certain server on the network

    I have found two ways to use to search

    a) sqlcmd -L

    b) WMI => wbemtest => namespace:root\directory\ldap => QUERY:SELECT * FROM ds_ms_sql_sqlserver

    Both methods return different results

    Please elaborate on both methods and also, what other different approaches can be taken to search for sql server(s) on a corporate network?

    Thank You Very Much

  • October 5, 2009 at 10:06 am

    #1061857

    I came across a blog post by Chrissy LeMaire[/url] that looked interesting, I'm not in a environment to try it though.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • October 5, 2009 at 10:33 am

    #1061870

    Thanks for the helpful link

    I just wonder how the information from WMI can be received without running a script but rather using wbemtest

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

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