KB-8734: How to use MSA (Managed Service Account) to run Reporting Service?
Question:
How to use MSA (Managed Service Account) to run Reporting Service?
Workaround:
Currently, using MSA to run Reporting Service is not supported in the User Interface. (RFE has been filed and accepted)
However, we use the following workarounds: If you hadn't deployed the Report Services, please firstly deploy it by using a domain account / built-in account as service account.
Create SQL login and user for the target MSA:
Open SQL Server Management Studio (SSMS) and connect to the instance which the Report Services is deployed to
Use SQL command to create SQL login for the target MSA, e.g.
create login [{MSA account} from Windows]
Create DB user for this SQL login under the DB which the Report Services is deployed to, and grant it as the role: SnapshotService
If you're using domain mode, make sure you've delegated the 'Replicate Directory Changes' permission to the target MSA
Start > Run > Services.msc > Locate Centrify Report Services and change it's service account to the target MSA > Restart the Report Services
Open Report Services Control panel > Troubleshooting > Click Validate to verify if the MSA is configured correctly.