| title | Validate a SQL Server Installation | Microsoft Docs | |
|---|---|---|
| description | The SQL Server discovery report can be used to verify the version of SQL Server and the SQL Server features installed on the computer. | |
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql | |
| ms.reviewer | ||
| ms.technology | install | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 1689af50-d2b8-4aa6-8f27-cc7127157fc8 | |
| author | cawrites | |
| ms.author | chadam | |
| monikerRange | >=sql-server-2016 |
[!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], [!INCLUDEssKatmai], [!INCLUDEssKilimanjaro], [!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=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/1180fffd45d5a9e9a10b2f1979105ead6e17860b/docs/database-engine/install-windows/RunDiscovery%22 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>.