[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 28
  • Last Modified:

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
0
Stefan
Asked:
Stefan
  • 2
3 Solutions
 
Nakul VachhrajaniTechnical 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 WeisslerProfessional 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
 
StefanAuthor 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
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
Question abandoned.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now