i didn’t find the uninstall/change option in Programs and Features to be very useful for determining which SQL server components are actually installed. this method also requires access to the original installation media.

a quicker method is to go to:
…Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log
and finding the Summary.txt file(s).

here’s an example of the file contents:

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 MSSQLSERVER MSRS10_50.MSSQLSERVER Reporting Services 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 Management Tools – Basic 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 Management Tools – Complete 1033 Standard Edition 10.50.1600.1 No
Sql Server 2008 R2 Integration Services 1033 Standard Edition 10.50.1600.1 No

Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
SPLevel: 0
Installation location: D:\x64\setup\
Installation edition: STANDARD

source:
http://www.sqlservercentral.com/Forums/Topic871318-391-1.aspx

Comments are closed.