This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 81%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
Additional SQL Server features and topics not covered by specific categories
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.
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
Hello Use Below Powershell to get a list of all the installed software in your server
Get-WmiObject -Class Win32_Product |select Name,Version
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 79%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
I would advise against ever using Win32_Product class. It is not query optimized. Simply running any query against the Win32_Product will cause a consistency-check/repair of all MSI-based applications installed on the host. You might lose application customizations if they were changed after install time, or you might cause performance issues.
See https://gregramsey.net/2012/02/20/win32_product-is-evil/ for more information.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 66%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
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.