Sample Header Ad - 728x90

how to list all features installed in a sql server instance?

6 votes
2 answers
28051 views
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?
Asked by Marcello Miorelli (17274 rep)
Jan 10, 2020, 06:50 PM
Last activity: Feb 28, 2025, 05:14 PM