Skip to content

Latest commit

 

History

History
31 lines (22 loc) · 3.3 KB

validate-a-sql-server-installation.md

File metadata and controls

31 lines (22 loc) · 3.3 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
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.
rwestMSFT
randolphwest
03/14/2017
sql
install
conceptual
validating installations [SQL Server]
>=sql-server-2016

Validate a SQL Server Installation

[!INCLUDE SQL Server -Windows Only]

The [!INCLUDEssNoVersion] discovery report can be used to verify the version of [!INCLUDEssNoVersion] and the [!INCLUDEssNoVersion] features installed on the computer. The Installed [!INCLUDEssNoVersion] features discovery report displays a report of all [!INCLUDEssVersion2000], [!INCLUDEssVersion2005], [!INCLUDEsql2008-md], [!INCLUDEsql2008r2], [!INCLUDEssSQL11], [!INCLUDEssSQL14], [!INCLUDEsssql16-md], and [!INCLUDEsssql17-md] products and features that are installed on the local server. The [!INCLUDEssNoVersion] features discovery report is available on the Tools page on the [!INCLUDEssNoVersion] Installation center.

Run [!INCLUDEssNoVersion] features discovery report

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

The [!INCLUDEssNoVersion] discovery report is saved to %ProgramFiles%\[!INCLUDEmsCoName] [!INCLUDEssNoVersion]\nnn\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%\[!INCLUDEmsCoName] [!INCLUDEssNoVersion]\nnn\Setup Bootstrap\Log\<last Setup Session>.

See also

View and Read SQL Server Setup Log Files