I received a query from one of my
team member: Is there a way to find out what all components of SQL Server are
installed in a server?
This is a useful information when we
want to set up a new SQL instance similar to an existing instance. Below is how
we can find out.
1. Login to
the server you want to find out what all SQL features are installed in it. In
my case its TEST server.
2. Open SQL
Server Installation Center.
3. In the
installation center click on the ‘Tools’ tab and click on ‘Installed SQL Server
features discovery report.’.
4. It will
open up a report like this.
Please add in comments in what other
ways we can find out what all SQL features installed in a server.
Thanks VV!!
#sqlfeatures, #sqlserver, #featuresinstalled, #installed, #sql, #server #report
#sqlfeatures, #sqlserver, #featuresinstalled, #installed, #sql, #server #report
