Home Forums SQL Server 2005 Administering Query / Script to get the information if my domain account has access to all the SQL Servers in my domain. RE: Query / Script to get the information if my domain account has access to all the SQL Servers in my domain.

  • ok forget the do it yourself thing: download this free program:

    SQLRecon[/url]

    it will scan your entire network in a LOT of differnet ways, and find all installations, including multiple instances ont he same server.

    it will try to connect to each of them IF you put in the credentials.

    here's a pair of screenshots from me hitting my network with ~40 servers/instances:

    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!