Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I find all the SQL servers installed in our network that were not installed by a DBA? Meaning, someone else has installed the SQL server and we need to get the details like SQL server version, instance name and port number so it can be added to our monitoring scripts.

share|improve this question

Use a network scanning tool that has the ability to fingerprint a node based on the ports that are open and the responses that the node gives back on those ports. Something like nmap or the Microsoft Assessment and Planning (MAP) Toolkit. Plenty of other network scanning tools exist that can detect what services are running on nodes. From there you can evaluate if the servers that are discovered to be running SQL Server are in your inventory or not.

share|improve this answer

Scanning all the systems SQL ERRORLOG file is one way to get all the details, without needing to auth to SQL itself.

Log file monitors can do this. You can do log file monitors on the OS, or within SQL Server itself.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.