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?

2 Answers 2


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

  • 1
    I doubt if this report give the level of details @Marcello is looking for. Commented Jan 10, 2020 at 20:29

Check out the Query written by Pawan:


  • The TSQL query in the link doesn't tell if replication is enabled or not.
    – RaviLobo
    Commented Apr 18, 2023 at 1:43
  • Link-only answers tend to be downvoted because the content will eventually go away. It is far better to capture the salient details and post them here, with a link back to the original article.
    – Hannah Vernon
    Commented Feb 8 at 16:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.