Many times, we need to find information about the various features / version of SQL Server installed on a machine. If you ask a DBA, he can provide you information by looking at services and tell what all are installed. He might run some WMI/T-SQL queries to list the services of SQL Server and their versions. Let us learn about the Discovery Report.
Well, we don’t need a DBA to do that and even Windows Admin (good news for Wintel team J) can do it. The SQL Server setup provides an option called “Installed SQL Server features Discovery Report” under Tools in Installation Center which can provide this information in a single place. Here is the installation center of the Start Menu.
Alternatively, we can also double click on setup.exe, which also launches installation center. Once launched, we can go to below option and click it. (Tools > Installed SQL Server features discovery report)
Once we click, it would fire setup.exe in the background and report various components installed and provide an HTML page as below.
As we can see it shows the version of all components installed not just SQL Engine.
Additional information:
- The SQL Server Discovery Report is saved to %ProgramFiles%\Microsoft SQL Server\version\Setup Bootstrap\Log\<date_timestamp>\SqlDiscoveryReport.htm.
In above version would be
- 100 for SQL 2008 and SQL 2008 r2
- 110 for SQL 2012
- 120 for SQL 2014
- 130 for SQL 2016
- … and so on
- We can also run this same report without coming to UI by running below command from a command prompt.
Setup.exe /q /Action=RunDiscovery
I have put /q for silent installation.
Have ever used this tool? I have used it for one of my clients today and they were surprised to see that they had an evaluation version of SQL installed.
Reference: Pinal Dave (https://blog.sqlauthority.com)
1 Comment. Leave new
Hello
I ran the Installed SQL Server features discovery report from SQL Server 2016 Installation center and I got a report which several products are listed as expected.
What was not expected is that these products are running different version
i.e. Database Engine Services, Full-Text and Semantic Extractions for Search and Data Quality Client are running the version 13.2.5426.0
While Client Tools Connectivity, Client Tools Backwards Compatibility and Client Tools SDK are running the version: 13.0.14500.10
We ran SQLServer2016-KB4505830-x64 setup to check if any feature needed to be upgraded to latest KB but the setup Wizard said that there is nothing to update.
We don’t understand the reason it exists different version between the features while all the features mentioned above were installed at the same time.
How should we proceed to align it to the same version: 13.2.5426.0.
In addition, we did not find any articles that clarify it.
I thank you in advance for your help.
Best regards
P a s c a L