snippetsqlMinor
how to list all features installed in a sql server instance?
Viewed 0 times
allsqlfeaturesinstancehowserverlistinstalled
Problem
There are other Installation related questions with similar details here and here.
I could not find anything related to
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:
A file which the name starts with
in that file, amongst other things I can find a list of the Sql Server Features installed:
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?
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_205540A 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:
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?
Solution
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
It is documented there: Validate a SQL Server Installation
Some examples: how-to-find-out-what-sql-features-are-installed
Context
StackExchange Database Administrators Q#257125, answer score: 7
Revisions (0)
No revisions yet.