How to list all features installed without run SQL Server setup?

Question

How to check which feature are installed without run the SQL Server setup? I mean, how can I list what was marked to install when running the SQL Server setup inside apkzity? That include Instance features and Shared Features.

Answer 1

That isn't trivial as some features are specific to SQL the server product while others are client (libraries and shared components). There isn't a reliable way to get the features that were installed as part of a SQL installation. Some of them may have been installed before or after SQL.

If you want to focus in on SQL services only and/or find the other things that were installed (from SQL or otherwise) then you have to use WMI and querying. Here's a SO post that will help get you started.

Answer 2

For services, you can use PowerShell to get services

There isn't a good way to query most of this stuff outside of the registry, and that would be complex as there isn't a single list. There is a discovery report from setup that you can run, and keep that around: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/validate-a-sql-server-installation?view=sql-server-ver16

Answer 3

Hello Use Below Powershell to get a list of all the installed software in your server

Get-WmiObject -Class Win32_Product |select Name,Version

Answer 4

Run the "SQL Server Discovery Report" to get a list of all installed SQL Server instances and they features. https://learn.microsoft.com/en-us/sql/database-engine/install-windows/validate-a-sql-server-installation?view=sql-server-ver16

Answer 5

Hi @ahmedbark,

Check out the Query:

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

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.