SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com

Discover SQL Server Components Installed Using SQL Server Discovery Tool

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
  • Language
  • 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)“.

SQL Server 2014 Installation Center

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.

Install SQL Server Feature Discovery Report in SQL Server to Identify Installed Components on 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.

Microsoft SQL Server 2014 Setup Discovery Report

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.

Open SQL Server Feature Discovery Report Using Command Prompt Action RunDiscovery

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.

Please wait while Microsoft SQL Server 2014 Setup processes the current operation

Important Note: Note: The Generated SQL Server Component Discovery Report will be saved for future reference in %ProgramFiles%\Microsoft SQL Server\130\Setup Bootstrap\Log\

Must Read SQL Server Articles for DBAs and Developers…

Ashish Mehta

Ashish Mehta

Ashish Kumar Mehta is a database manager, trainer and technical author. He has more than a decade of IT experience in database administration, performance tuning, database development and technical training on Microsoft SQL Server from SQL Server 2000 to SQL Server 2014. Ashish has authored more than 325 technical articles on SQL Server across leading SQL Server technology portals. Over the last few years, he has also developed and delivered many successful projects in database infrastructure; data warehouse and business intelligence; database migration; and upgrade projects for companies such as Hewlett-Packard, Microsoft, Cognizant and Centrica PLC, UK. He holds an engineering degree in computer science and industry standard certifications from Microsoft including MCITP Database Administrator 2005/2008, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

Newsletter Signup! Join 15,000+ Professionals




Be Social! Like & Follow Us...

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.

Recent SQL Server Tips

Manning