Post reply

Finding "all" SQL Servers on the domain

  • March 2, 2004 at 1:00 pm

    #84309

    I know [I've used 5 months ago] that there is a command line (MS-DOS) which searches the network for all (on-line) SQL Servers.

    I have been in medical leave and things have change here quite a while, so I like to get a good listing of all the old and new MS SQL Servers in the network.

    I appreciate any prompt response so I can start to get busy with my DBA tasks.

    Thanks sincerely,

    Leo C.

  • March 2, 2004 at 1:11 pm

    #496754

    Although I don't know of such a command line tool, I bet you'll find several scripts in the script section. So I would search the site.

    Don't get too soon too busy!

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • March 2, 2004 at 1:38 pm

    #496757

    I believe the tool that you are looking for is SQLPing, you can download it from http://www.sqlsecurity.com/

    Works great, unless of course you have the server behind a properly configured firewall....you do have that right? Or are you just looking for "rogue installs"?


    Shamless self promotion - read my blog http://sirsql.net

  • March 2, 2004 at 5:13 pm

    #496786

    Try this:

    osql -L

    or

    isql -L

    But results might not be 100% accurate.

    Igor

     

  • March 3, 2004 at 1:37 am

    #496826

    what about opening Control Panel >> Data source (ODBC) ...

    and make a new DSN ... and choose SQL Server .. then in Server combo box .. you will find All worked (and may be non worked) servers


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

Viewing 5 posts - 1 through 4 (of 4 total)

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