This is a quick guide on how to check which features are installed on a SQL Server.
Open your SQL Server installation files. You may find them within the Setup Bootstrap folder (“C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\SQL2019”) or you might already have the ISO handy.
We can open cmd.exe from the top navigation bar.
Then run the Setup.exe with the /ACTION=RunDiscovery parameter (Microsoft Docs – Installation Parameters).
The SQL Server discovery report is saved to %ProgramFiles%\MicrosoftSQL Server\nnn\Setup Bootstrap\Log\<last Setup Session>.
‘nnn’ is whatever version of SQL Server you have:
# SQL Server 2012 (110)
# SQL Server 2014 (120)
# SQL Server 2016 (130)
# SQL Server 2016 (130)
# SQL Server 2017 (140)
# SQL Server 2019 (150)
If you’re using PowerShell, Get-Content will work… tab your way through the sub-folders.
The highlighted area above shows only the Database Engine Services are installed of SQL Server 2019 Developer Edition.
Leave a Reply