1. Download SQL Server Reporting Services
  2. Prepare gMSA for SSRS
    • New-ADServiceAccount -Name svc_CM_SSRS -SamAccountName svc_CM_SSRS -DNSHostName adcm01.ad.ajf8729.com -KerberosEncryptionType AES128,AES256 -Path "OU=CM,OU=Servers,OU=AJF8729,DC=ad,DC=ajf8729,DC=com" -PrincipalsAllowedToRetrieveManagedPassword (Get-ADGroup -Identity CM_Servers)
    • Install-ADServiceAccount -Identity svc_CM_SSRS
    • Test-ADServiceAccount -Identity svc_CM_SSRS
    • Restart-Computer
    • Grant gMSA “Log on as a service” URA in ConfigMgr GPO
  3. Install SSRS
    • SQLServerReportingServices.exe /passive /norestart /InstallFolder="E:\Program Files\Microsoft SQL Server Reporting Services" /IAcceptLicenseTerms /Edition=Dev
  4. Configure SSRS
  5. Create Reporting Services Point account
    • New-ADUser -Name svc_CM_RSP -SamAccountName svc_CM_RSP -CannotChangePassword $true -PasswordNeverExpires $true -Path "OU=CM,OU=Servers,OU=AJF8729,DC=ad,DC=ajf8729,DC=com" -AccountPassword (Read-Host -Prompt "Enter password" -AsSecureString) -KerberosEncryptionType AES128,AES256 -ChangePasswordAtLogon $false -DisplayName svc_CM_RSP -Enabled $true -UserPrincipalName "svc_CM_RSP@ad.ajf8729.com" -Description "ConfigMgr Reporting Services Point Account"
  6. Install Reporting Services Point
    • New-CMAccount -UserName "AD\svc_CM_RSP" -Password (Read-Host -Prompt "Enter password" -AsSecureString)
    • Add-CMReportingServicePoint -SiteSystemServerName adcm01.ad.ajf8729.com -DatabaseServerName adcm01.ad.ajf8729.com -DatabaseName CM_AD0 -FolderName ConfigMgr_AD0 -ReportServerInstance SSRS -UserName "AD\svc_CM_RSP"