Get a list of installed SQL Server Components with SQL Server Discovery Tool

Usually, DBA needs to check the SQL Server and find out the answer to the following questions:

  • What's components are installed on your local SQL instances?

  • What version of the different SQL Server components are installed on a server?


SQL server discovery tool is a popular utility among SQL database administrators that quickly identify SQL components and associated information.


To view the SQL Server discovery report, launch SQL Server Installation Center. For example, in SQL 2019, launch SQL Server 2019 installation center (64-bit) as shown below.



SQL Server Discovery Report

In the installation center, go to Tools and click on – Installed SQL Server Features discovery report.


Installed SQL Server features discovery report

My demo SQL Server has the database engine services and client tools connectivity, as shown below. The report helps to identify the components and their versions on the server.


Viw discovery report

You can also view this discovery report in the Setup BootStrap folder. For my demo SQL Server 2019 instance, the location for Setup Bootstrap is C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log.

Open the latest folder from the Log folder, and you can see the HTML document- SqlDiscoveryReport.HTML


View discovery report in Setup Bootstrap folder


18 views0 comments