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

ahmedbark 0 Reputation points
2024-02-08T14:29:56.7166667+00:00

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
    2024-02-08T15:57:29.79+00:00

    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
    2024-02-08T18:04:50.9+00:00

    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

    0 comments No comments

  3. Javier Villegas 895 Reputation points MVP
    2024-02-08T18:23:32.8033333+00:00

    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
    2024-02-08T18:49:07.16+00:00

    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

    0 comments No comments

  5. ZoeHui-MSFT 30,411 Reputation points
    2024-02-09T03:12:27.43+00:00

    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.

    0 comments No comments