MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter























Latest SQL Server Tips














Discover SQL Server Components Installed Using SQL Server Discovery Tool

Read Comments   |   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
  • Language
  • 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)".

Using SQL Server 2014 Installation Center to Discover SQL Server Components Installed on SQL Server

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

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.

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

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

References

Learn More...

Get to know about SQL Server Build List for below SQL Server Versions







Last Updated On: Mar 27, 2015



Share this Article



Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips




Please leave your Valuable Comment or Let us know how this article helped you: