How to identify what features has been installed in your SQL Server

How to view the list of features installed in the SQL Server easily without going through “Programs and Features” or “Services”.


Yes, there is an easy way.

Method 1: 

we can navigate to the Following Path and see the summary file.

SQL server 2012 Features Installation Discovery.

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\Summary.txt

SQL Server 2008 Features Installation Discovery.

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\Summary.txt

Method 2:

Second method is you can go to the Startup and choose the SQL Server Installation Center.

Select Tools on the Left side  and choose Installed SQL Server Features Discovery Report

you will get the Report in internet explorer.

Regards

R.Karthikeyan