Post reply

Discover online SQL servers

  • February 2, 2004 at 8:42 am

    #83925

    My company is a big MS SQL server shop. I usually use OSQL _L command, howerver, it will miss some SQL servers due to different domain, network etc. I would like whether there is a better way to do that.

    Thanks in advance

     

     

     

     

  • February 2, 2004 at 8:54 am

    #492502

    Try SQL Server security tools scan.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;813944&Product=sql2k

     

  • February 2, 2004 at 10:46 am

    #492509

    Since slammer, 1434 has been turned off in many places and discovery has been tough. SMS has worked well here in querying for SQL services.

  • February 2, 2004 at 12:56 pm

    #492528

    We use BindView to do this for us.  It seems to work pretty well.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • February 3, 2004 at 7:41 am

    #492613

    Thank you all for the advices!

     

    John

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

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