Discover SQL Server Components Installed Using SQL Server Discovery Tool
Related Topics: SQL Server Management Studio Tips>
Next Topic: Database Backup & Restore Tips
Introduction to Microsoft SQL Server Setup Discovery Report
Microsoft Introduced SQL Server Discovery Tool in SQL Server 2008. Since then it 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 instal 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, and SQL Server 2014 .
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.
Thank you for taking your time to read
this article. Let's be Connected....
Sign-up for Our Newsletter to Get Free SQL Server Tips and News to Build your Career
Like MyTechMantra on Facebook to get updates on What's Happening in SQL Server
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.
Note: The Generated SQL Server Component Discovery Report will be saved for future reference in
%ProgramFiles%\Microsoft SQL Server\130\Setup Bootstrap\Log\
- Database Corruption: How to Fix SQL Server Database Corruption Issues
- DBA Tutorial: SQL Server Database Backup Tutorial for DBAs and Developers
- SSMS: SQL Server Management Studio Tips and Tricks
- SSAS: SQL Server Analysis Services (SSAS) Administration Tips for DBAs and Developers
Get to know about SQL Server Build List for below SQL Server Versions
- SQL Server 2014 Build List or SQL Server 2014 Build Versions
- SQL Server 2012 Build List or SQL Server 2012 Build Versions
- SQL Server 2008 R2 Build List or SQL Server 2008 R2 Build Versions
- SQL Server 2008 Build List or SQL Server 2008 Build Versions
- SQL Server 2005 Build List or SQL Server 2005 Build Versions
Last Updated On: Mar 27, 2015
Please leave your Valuable Comment or Let us know how this article helped you: