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

ahmedbark 0 Reputation points

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. 9yqzi

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,247 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. Michael Taylor 44,136 Reputation points

    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.

    0 comments No comments

  2. way0utwest 1 Reputation point MVP

    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:

    0 comments No comments

  3. Javier Villegas 895 Reputation points MVP

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

    Get-WmiObject -Class Win32_Product |select Name,Version
    0 comments No comments

  4. Olaf Helper 38,861 Reputation points

    Run the "SQL Server Discovery Report" to get a list of all installed SQL Server instances and they features.

    0 comments No comments

  5. ZoeHui-MSFT 30,411 Reputation points

    Hi @ahmedbark,

    Check out the Query:


    Zoe Hui

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

    0 comments No comments