5

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?

Marcello Miorelli
  • 16,170
  • 52
  • 163
  • 300

2 Answers2

7

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

Piotr Palka
  • 1,581
  • 9
  • 15
2

Check out the Query written by Pawan:

http://pawansingh1431.blogspot.com/2011/02/check-what-are-sql-components-installed.html

Robert Rubinberg
  • 75
  • 5
  • The TSQL query in the link doesn't tell if replication is enabled or not. – RaviLobo Apr 18 '23 at 01: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 Feb 08 '24 at 16:34