Post reply

Scan network for SQL server installations

  • September 17, 2009 at 7:25 am

    #211000

    Hi Guys

    I used to have a tool which once installed will scan the network for all SQL isntallations, informs you of the hostname, IP address and what version of SQL. I dont know the name of the tool, was wondering if anyone has seen or used a similar tool, and it was also free.

    Thanks.

  • September 17, 2009 at 7:31 am

    #1054965

    Dean Jones-454305 (9/17/2009)

    Hi Guys

    I used to have a tool which once installed will scan the network for all SQL isntallations, informs you of the hostname, IP address and what version of SQL. I dont know the name of the tool, was wondering if anyone has seen or used a similar tool, and it was also free.

    Thanks.

    SQLPing?

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

  • September 17, 2009 at 9:30 am

    #1055070

    Quest as free tool as well called Quest Discovery Wizard for SQL Server.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • September 17, 2009 at 9:39 am

    #1055079

    Run

    OSQL -L

    from a command line on a SQL server to get the netbios names of all instances.

  • September 17, 2009 at 10:41 am

    #1055125

    also SQLRecon; it uses a combination of different techniques to find all the registrations, their versions, and more...even identifies blank "sa" password installations.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 17, 2009 at 10:53 am

    #1055131

    Lowell (9/17/2009)

    also SQLRecon; it uses a combination of different techniques to find all the registrations, their versions, and more...even identifies blank "sa" password installations.

    As lowell has mentioned and from your description, it looks like you are looking for SQLRecon (just google it).

    There are also vbscripts and wmi script examples on the net of how to do the same thing - if you're inclined or have the time. With those, you would be able to create your own customized SQL Inventory report.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • September 17, 2009 at 11:59 am

    #1055179

    "Microsoft Assessment and Planning Toolkit"

Viewing 7 posts - 1 through 6 (of 6 total)

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