SQL Server 2016 – How to List All Features Installed in an Instance

automationinstallationlogssql serversql-server-2016

There are other Installation related questions with similar details here and here.

I could not find anything related to listing the installed features in sql server 2016 though.

I can do it manually looking at the logs – as per the info below, but I would like to automate it.

After installing SQL Server 2016 I get a log file – located somewhere in these folders:

C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20200109_205540

enter image description here

A file which the name starts with Summary_ +my_server_name

in that file, amongst other things I can find a list of the Sql Server Features installed:
enter image description here

After installation, later on when the systems are already in use, logins and permissions applied, firewall fixed, etc.

Is there a simple way to get hold of the list of features installed on a sql server instance?

Best Answer

You can run "Installed SQL Server features discovery report"

It is documented there: Validate a SQL Server Installation

Some examples: how-to-find-out-what-sql-features-are-installed

Related Question