What are the features supported on Sql Server 2019?

[aledeniz]

I have tried to configure a pre-existing Sql Server 2019, deployed with all the features.
I had to prune the list of features to get it to work:

#\Features             	= 'SQLENGINE,REPLICATION,ADVANCEDANALYTICS,SQL_INST_MR,SQL_INST_MPY,SQL_INST_JAVA,FULLTEXT,DQ,POLYBASECORE,POLYBASEJAVA,AS,SQL_SHARED_AA,SQL_SHARED_MR,SQL_SHARED_MPY,DQC,CONN,IS,IS_MASTER,IS_WORKER,BC,SDK,DREPLAY_CTLR,DREPLAY_CLT,SNAC_SDK,MDS'
Features             	= 'SQLENGINE,REPLICATION,DQ,DQC,FULLTEXT,AS,IS,CONN,BC,SDK,MDS'

Is this the expected list of supported features, or should/could I try to add more?

My configuration at this point in time looks like the below (I am using gMSAs):

Configuration SqlInstall
{
    [CmdletBinding()]
    param
    (
        [Parameter(Mandatory = $true)]
        [ValidateNotNullOrEmpty()]
        [System.Management.Automation.PSCredential]
        $AgentServiceInstallCredential,
        [Parameter(Mandatory = $true)]
        [ValidateNotNullOrEmpty()]
        [System.Management.Automation.PSCredential]
        $AnalysisServiceInstallCredential,
        [Parameter(Mandatory = $true)]
        [ValidateNotNullOrEmpty()]
        [System.Management.Automation.PSCredential]
        $IntegrationServiceInstallCredential,
        [Parameter(Mandatory = $true)]
        [ValidateNotNullOrEmpty()]
        [System.Management.Automation.PSCredential]
        $DatabaseEngineServiceInstallCredential,
        [Parameter(Mandatory = $true)]
        [ValidateNotNullOrEmpty()]
        [System.Management.Automation.PSCredential]
        $RunAsInstallCredential
    )

    Import-DscResource -ModuleName PSDesiredStateConfiguration
    Import-DscResource -ModuleName 'SqlServerDsc'    
    
    node localhost
    {

        SqlSetup 'InstallDefaultInstance'
        {
        
            InstanceName            = 'MSSQLSERVER'
            #\Features              = 'SQLENGINE,REPLICATION,ADVANCEDANALYTICS,SQL_INST_MR,SQL_INST_MPY,SQL_INST_JAVA,FULLTEXT,DQ,POLYBASECORE,POLYBASEJAVA,AS,SQL_SHARED_AA,SQL_SHARED_MR,SQL_SHARED_MPY,DQC,CONN,IS,IS_MASTER,IS_WORKER,BC,SDK,DREPLAY_CTLR,DREPLAY_CLT,SNAC_SDK,MDS'
            Features                = 'SQLENGINE,REPLICATION,DQ,DQC,FULLTEXT,AS,IS,CONN,BC,SDK,MDS'
            SQLCollation            = 'SQL_Latin1_General_CP1_CI_AS'
            #CLTSVCACCOUNT          = 'VS\DB-DC$'
            #CTLRSVCACCOUNT         = 'VS\DB-DR$'
            #PBENGSVCACCOUNT        = 'VS\DB-PB$"'
            #PBDMSSVCACCOUNT        = 'VS\DB-PB$"'
            AgtSvcAccount           = $AgentServiceInstallCredential
            AgtSvcStartupType       = 'Manual'
            ISSvcAccount            = $IntegrationServiceInstallCredential
            IsSvcStartupType        = 'Automatic'
            #ISMASTERSVCACCOUNT     = 'VS\DB-SM$'
            #ISWORKERSVCACCOUNT     = 'VS\DB-SW$'
            ASSvcAccount            = $AnalysisServiceInstallCredential
            AsSvcStartupType        = 'Automatic'
            SQLSvcAccount           = $DatabaseEngineServiceInstallCredential
            SqlSvcStartupType       = 'Automatic'
            #EXTSVCACCOUNT          = "NT Service\MSSQLLaunchpad"
            #FTSvcAccount           = "NT Service\MSSQLFDLauncher"
            SQLSysAdminAccounts     = 'VS\DB Administrators'
            ASSysAdminAccounts      = 'VS\DB Administrators'
            InstallSharedDir        = 'C:\Program Files\Microsoft SQL Server'
            InstallSharedWOWDir     = 'C:\Program Files (x86)\Microsoft SQL Server'
            InstanceDir             = 'C:\Program Files\Microsoft SQL Server'
            InstallSQLDataDir       = 'E:\DB\MSSQL15.MSSQLSERVER\MSSQL\Data'
            SQLUserDBDir            = 'E:\DB\MSSQL15.MSSQLSERVER\MSSQL\Data'
            SQLUserDBLogDir         = 'E:\DB\MSSQL15.MSSQLSERVER\MSSQL\Data'
            SQLTempDBDir            = 'E:\DB\MSSQL15.MSSQLSERVER\MSSQL\Data'
            SQLTempDBLogDir         = 'E:\DB\MSSQL15.MSSQLSERVER\MSSQL\Data'
            SQLBackupDir            = 'E:\DB\MSSQL15.MSSQLSERVER\MSSQL\Backup'
            ASServerMode            = 'TABULAR'
            ASConfigDir             = 'C:\Program Files\Microsoft SQL Server\MSAS15.MSSQLSERVER\OLAP\Config'
            ASDataDir               = 'E:\DB\MSAS15.MSSQLSERVER\OLAP\Data'
            ASLogDir                = 'E:\DB\MSAS15.MSSQLSERVER\OLAP\Log'
            ASBackupDir             = 'E:\DB\MSAS15.MSSQLSERVER\OLAP\Backup'
            ASTempDir               = 'E:\DB\MSAS15.MSSQLSERVER\OLAP\Temp'
            ASCollation             = 'Latin1_General_CI_AS'
            SourcePath              = 'F:\'
            UpdateEnabled           = $true
            ForceReboot             = $false
            SqlTempdbFileCount      = 4
            SqlTempdbFileSize       = 1024
            SqlTempdbFileGrowth     = 512
            SqlTempdbLogFileSize    = 128
            SqlTempdbLogFileGrowth  = 64
            BrowserSvcStartupType   = 'Disabled'
            
            PsDscRunAsCredential    = $RunAsInstallCredential
        }
    }
}

$configurationData = @{
    AllNodes = @(
        @{
            NodeName = 'localhost'
            PSDscAllowDomainUser = $true
            PSDscAllowPlainTextPassword = $true
        }
    )
}

$ServiceAccountPassword = ConvertTo-SecureString 'Using_gMSAs' -AsPlainText -Force
$IntegrationServiceInstallCredential = (New-Object -TypeName System.Management.Automation.PSCredential 'VS\DB-IS$', $ServiceAccountPassword)
$AnalysisServiceInstallCredential = (New-Object -TypeName System.Management.Automation.PSCredential 'VS\DB-AS$', $ServiceAccountPassword)
$AgentServiceInstallCredential = (New-Object -TypeName System.Management.Automation.PSCredential 'VS\DB-AG$', $ServiceAccountPassword)
$DatabaseEngineServiceInstallCredential = (New-Object -TypeName System.Management.Automation.PSCredential 'VS\DB-DE$', $ServiceAccountPassword)

$Parameters = @{
  AgentServiceInstallCredential = $AgentServiceInstallCredential
  AnalysisServiceInstallCredential = $AnalysisServiceInstallCredential
  DatabaseEngineServiceInstallCredential = $DatabaseEngineServiceInstallCredential
  IntegrationServiceInstallCredential = $IntegrationServiceInstallCredential
  ConfigurationData = $configurationData
  RunAsInstallCredential = $RunAsInstallCredential
}

SQLInstall @Parameters

[johlju]

Not all features are yet supported, please open separate issues for any that currently does not have an issue tracking it. Contributions to support more are much appreciated. The currently supported features are not documented in the README.md either so a contribution to add that would be great too.

It would have been better if the Features parameter was an array of feature names, then we could have had a ValidateSet() that listed the currently supported features and the configuration would throw an exception when it was compiled instead of how it is now that it is only shown once the Test-TargetResource function is run (and returns $false).

Features supported (might not be available on all major versions)

• SQLENGINE
• REPLICATION
• DQ
• DQC
• BOL
• CONN
• BC
• SDK
• MDS
• FULLTEXT
• RS
• AS
• IS
• SSMS
• ADV_SSMS

[jeremiahmoree-adot]

Realize that this is closed and appreciate the additional documentation but what do all of those acronyms mean? What is DQ? etc.