1. Create Reporting Services Point account
    • New-ADUser -Name svc_CM_DW -SamAccountName svc_CM_DW -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_DW -Enabled $true -UserPrincipalName "svc_CM_DW@ad.ajf8729.com" -Description "ConfigMgr Data Warehouse Service Point Account"
  2. Install Reporting Services Point
    • New-CMAccount -UserName "AD\svc_CM_DW" -Password (Read-Host -Prompt "Enter password" -AsSecureString)
    • Add-CMDataWarehouseServicePoint -SiteSystemServerName adcm01.ad.ajf8729.com -DataWarehouseDatabaseServerName adcm01.ad.ajf8729.com -DataWarehouseDatabaseName CM_AD0_DW -DataWarehouseSqlPort 1433 -UserName "AD\svc_CM_DW"