Issue with Installing Analysis Services via dbatools

[suhaylsidat]

Hello

I'm trying to install SQL Server using Install-DbaInstance (dbatools) to automate SQL Server installation across local and remote Windows Server environments with customisable configuration.

I have a working script which executes very well even when installing other features like Integration Services, Full-Text etc.

However, I am trying to use the same script with the addition of Analysis Services, but I am getting an error message in the log saying "You must provision the system with at least one system administrator".

I know that I need to include the admin account for Analysis Services. In my script, I am including this feature in the 'Feature' parameter, along with the AdminAccount (for the default SQL Instance) and the ASCredential parameters in the $config. I'm not sure if there's something missing but I don't see any option to include the Admin account for Analysis Services.

Please can you advise?
Thanks

[niphlod]

maybe @suhaylsidat post what are you using right now (as the script using Install-DbaInstance) that shows the error.

[suhaylsidat]

maybe @suhaylsidat post what are you using right now (as the script using Install-DbaInstance) that shows the error.

Thanks @niphlod, here's the script I'm currently using:

==================================================================================

#Requires -Modules @{ ModuleName="SqlServer"; ModuleVersion="21.1.18256" }

#mount ISO
$mountResult = Mount-DiskImage "C:\TEMP\SW_DVD9_NTRL_SQL_Svr_Standard_Edtn_2022_64Bit_English_OEM_VL_X23-28393.ISO" -PassThru
$driveLetter = ($mountResult | Get-Volume).DriveLetter
Set-DbatoolsConfig -Name Path.SQLServerSetup -Value "$driveLetter`:"

#set parameters
$Computer = Read-Host "Please enter host server name"
$version = 2022

#get service account credentials
$sacredential = get-credential -Message "sa account"
$EngineCredential = get-credential -Message "Engine"
$AgentCredential = get-credential -Message "Agent"
$ISCredential = get-credential -Message "SSIS"

$config = @{
ComputerName = $Computer
Version = $version
SqlCollation = "Latin1_General_CI_AS"
AuthenticationMode = "Mixed"
Feature = "Engine","FullText","IntegrationServices","AnalysisServices"
InstancePath = "D:\Program Files\Microsoft SQL Server"
SaCredential = $sacredential
EngineCredential = $EngineCredential
AgentCredential = $AgentCredential
ISCredential = $ISCredential
ASCredential = $EngineCredential
AdminAccount = "AD\MSSQLAdmins"
DataPath = "E:\Data"
LogPath = "F:\Log"
TempPath = "G:\TempDB"
BackupPath = "E:\Backup"
PerformVolumeMaintenanceTasks = $true
Confirm = $false
Restart = $false
}

$result = Install-DbaInstance @config
$result | Format-Table
if (-not $result.Successful) {
throw "Failed to install SQL Server"
}