List of all installed SQL Servers in our network

Hello Experts !

Our serverdocumentation isn't up to date and i should deliver a list of all installed SQL Servers in our Network.

Can someone give me a tipp how can i find out this SQL Server informations ( Versions ) with a tool ?

Many thanks in advance
Stefan
StefanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
StefanConnect With a Mentor Author Commented:
I got SQL Server informations with Microsoft Assessment and Planning (MAP) Toolkit for SQL Server. It's very complex and detailed, exactly what i want.

Again thank you for your tip.
0
 
Nakul VachhrajaniConnect With a Mentor Technical Architect, Capgemini IndiaCommented:
You can enumerate through the installed instances using the simple sample on MSDN here: https://msdn.microsoft.com/en-us/library/a6t1z9x2(v=vs.110).aspx

NOTE: If an instance has been explicitly hidden by the administrators by changing the properties of the SQL Server Browser service on the server, this script may not be able to identify these instances.
1
 
Rich WeisslerConnect With a Mentor Professional Troublemaker^h^h^h^h^hshooterCommented:
Do you happen to have software auditing of some sort available?  (System Center Configuration Manager (SCCM) would be one option for example, or some endpoint protection suites include software inventory functionality as well.)
You can get a partial picture of your installed SQL Server instances, by querying the default port (tcp/1433), or querying the SQL Browser, but the Browser can be disabled, and SQL can be configured to not listen on the default port (or any port).  For those reasons, my first suggestion would be a client which collects software inventory.
0
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Question abandoned.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.