We are trying to configure Reporting Services to use a Managed Service Account. The environment is:
Server: Windows 2008 R2 SP1
Reporting Services: SQL Server 2012 (version 11.0.6567.0)
Currently, SSRS runs as a domain service account, but we would like to change to running as an MSA. The SQL Server instance and agent have both been successfully changed to use an MSA.
When I try to change the service account to an MSA, via Reporting Services Configuration Manager, I receive an error:
Microsoft.ReportingServices.WmiProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias.
—> System.Runtime.InteropServices.COMException (0x8004021D): Exception from HRESULT: 0x8004021D
— End of inner exception stack trace —
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.SetWindowsServiceIdentity(String accountName, SecureString password, Boolean useBuiltinAccount)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWindowsServiceIdentity(String accountName, SecureString password, Boolean useBuiltinAccount)
My question is simple:
Has anyone successfully changed the SSRS service account to use a Managed Service Account? If so, how?!
Best Answer
Yes you can run SSRS with a Managed Service Account.
I would double check that your MSA is installed on your SSRS server. You can do so with Powershell.
If your SSRS server is not listed, you will need to install the MSA on the server. This needs to be run locally (on SSRS server). You MUST be domain admin to run Install-ADServiceAccount successfully.