Validate a SQL Server Installation

The SQL Server discovery report can be used to verify the version of SQL Server and the SQL Server features installed on the computer. The Installed SQL Server features discovery report displays a report of all SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 products and features that are installed on the local server. The SQL Server features discovery report is available on the Tools page on the SQL Server Installation center.

To run SQL Server features discovery report:

Launch the SQL Server Installation center, using the Start menu, point to All Programs, point to Microsoft SQL Server <Version Name>, point to Configuration Tools, and click SQL Server Installation Center. To run the SQL Server features discovery report, click Tools in the left-hand navigation area of SQL Server Installation Center, and then click Installed SQL Server features discovery report.

The SQL Server discovery report is saved to %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Log\<last Setup Session>.

You can also generate the discovery report through the command line. Run “Setup.exe /Action=RunDiscovery” from a command prompt If you add “/q” to the command line above no UI will be shown, but the report will still be created in %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Log\<last Setup Session>.

See Also

Concepts

View and Read SQL Server Setup Log Files