Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers 2

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
add comment

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
add comment

Your Answer

 
discard

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.