How can I determine which SQL Server features and versions are on my computer?

 

This continues to be one of the more frequently asked questions on the MSDN Forums and is important for many reasons, including patching, security, compatibility with other applications, network compliance, and even troubleshooting failed installs.  Over the years, I've pointed many people to Peter Saddow's 2009 blog entry highlighting the introduction of the Discovery Report feature included within SQL Server setup as part of the SQL Server 2008 release.  Since there have been two major releases of SQL Server since the blog entry was written, I wanted to update the blog entry with the SQL Server 2012 version of Discovery Report.

The Discovery Report feature is included in the SQL Server Installation Center, which can be launched from the Start menu or from the corresponding tile (based on your OS):

This will launch SQL Server 2012 setup.  Click on the Tools node, then on the link for "Installed SQL Server features discovery report".

 

This will produce the report of all discovered versions/components of SQL Server that exist on your machine.  The report looks like:

 

The SQL Server Discovery Report is saved to %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Log\<last Setup Session>\SqlDiscoveryReport.htm.

 

Hope this helps,
Sam Lester (MSFT)