How to find what all features of SQL Server are installed in the server.

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