Microsoft Introduced SQL Server Discovery Tool is widely used by SQL Server Database Administrators to quickly identify SQL Server Components which are already installed on a local SQL Server. The report shown in the snippet below will give DBA a complete overview of all the SQL Server Components which are installed for a specify instance of SQL Server.
In this article we will take a look at how to install and use SQL Server Discovery Tool to discover all the SQL Server Components which are already installed on a local server.
SQL Server Discovery Report includes
- Product Name
- Instance Name
- Instance ID
- SQL Server Feature / SQL Server Component
- SQL Server Edition
- Version or Build Number
- Clustered or Non Clustered
- Configuration Status
Once you install SQL Server features Discovery Report it will display a report for products and features that are installed on the local server for SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016.
SQL Server Feature Discovery Report can be generated in two different ways:
- Open SQL Server Discovery Report Using SQL Server Installation Center
- Open SQL Server Discovery Report Using Command Prompt
Let us discuss each of the above options in detail.
Open SQL Server Feature Discovery Report Using SQL Server Installation Center
Login to Server and right click Start and click Search option. In the Search enter “SQL Server 2014” and then select any version of “SQL Server Installation Center” as shown in the snippet below. On our local server SQL Server 2014 was installed hence I would click “SQL Server 2014 Installation Center (64-bit)“.
In SQL Server Installation Center click on Tools on the left pane and click on “Installed SQL Server features Discovery Report” as highlighted in the snippet below.
This will open up Microsoft SQL Server 2014 Setup Discovery Report in your default browser with all the relevant information as shown in the snippet below.
Open SQL Server Feature Discovery Report Using Command Prompt
Open SQL Server Installation Folder from where you had installed SQL Server. Yes, you need to remember it. As a best practice we recommend you to store an installation setup copy on the server as this helps you during feature or component installation as well as during disaster recovery. In our scenario the installation setup is located on “G:\Softwares\SQLServer2014\” folder.
Open Command Prompt and then navigate to the SQL Server Setup Folder and type “Setup.exe /Action=RunDiscovery” as shown in the snippet below. To generate the report hit ENTER.
In a while you will see the below popup window as shown in the snippet below and once the popup closes you will see the Microsoft SQL Server 2014 Discovery Report which will open up in your default browser. Take a look at the above section to view different data which is captured by the report.
Must Read SQL Server Articles for DBAs and Developers…
- FORMAT SQL Server Dates Using FORMAT Function in SQL Server
- How to Move TempDB to New Drive in SQL Server
- Display Line Numbers in SQL Server Management Studio (SSMS)
- Drop Database in SQL Server by Killing Existing Connections
- How to Verify and Register SPN for SQL Server Authentication with Kerberos Connections
- How to Enable and Refresh IntelliSense in SQL Server Management Studio (SSMS)
- How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio
- SQL Server Best Practice Auto Close Database Option Should Remain OFF
- Identify Deadlocks in SQL Server Using Trace Flag 1222 and 1204