Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayValidate a SQL Server Installation
Applies to: 
SQL Server - Windows only
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 (8.x), SQL Server 2005 (9.x), SQL Server 2008 (10.0.x), SQL Server 2008 R2 (10.50.x), SQL Server 2012 (11.x), SQL Server 2014 (12.x), SQL Server 2016 (13.x), and SQL Server 2017 (14.x) 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.
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\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%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\<last Setup Session>.
Additional resources
Training
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
-
Add Features to an Instance of SQL Server (Setup) - SQL Server
This article provides a step-by-step procedure for adding instance-aware features to an instance of SQL Server 2019.
-
Work with multiple versions and instances - SQL Server
You can install multiple instances of SQL Server or install SQL Server on a computer where earlier SQL Server versions are already installed.
-
Error if you change shared component directory - SQL Server
This article provides workarounds for the problem that occurs when you change the path in the shared component directory box on the Feature Selection screen of the Install SQL Server 2008 Setup wizard.