SQL Server 2008: View Installed Features

Problem

You need to view the features installed on a SQL Server 2008 R2 instance. 

Discussion

There are at least two ways of going about this: using SQL Server Installation Center (installed and also available on the original installation DVD) and viewing setup files.  I haven't yet researched it, but I believe that you can also view installed features via PowerShell, but you may need to install the PowerShell for SQL Server first and run some configuration before you can do it.

Solution

1. Use the SQL Server Installation Center:
1. Go: Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Installation Center.  The familiar installation dialog appears.
   
2. Click Installed SQL Server features discovery report.  The report is generated and presented as a web page.
   
2. Use saved setup reports:
1. Go to: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log.  Each running of setup or the discovery report generates data that is saved here.
   
   
2. Open the file, Summary.txt.  This file contains the configuration details from the most recent setup or discovery operation.
   

References

• Validate a SQL Server Installation
• View and Read SQL Server Setup Log Files
• How to identify SQL Server 2008 setup issues in the setup log files
• Query to see what components or features are installed
• SQL Server Powershell is here!
• SQL Server Perceptions