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.
In the installation center, go to Tools and click on – 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.
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
Comments