I have two questions please:
- BOL tells me that Group Managed Service Accounts (gMSAs) are not supported as a report server service account. BOL Reference - Configure the Report Server Service Account (Report Server Configuration Manager)
however, some articles I've seen on the internet seem to be suggesting that more recent versions of SQL can use gMSAs even though BOL doesn't say that. Is this correct?
- For the SQL instance in question, I have tried using the gMSA that both the Engine and Agent services run successfully under and I get a similar error as I get when I use the built in Virtual Service Account. The error message is: Login failed for user 'NT SERVICE\SQLServerReportingServices'. Reason: Failed to open the explicitly specified database 'ReportServer'. … Error: 18456, Severity: 14, State: 38.
Obviously for the gMSA the error message is with that account name.
My preference will be to use the gMSA if that is indeed supported for SQL 2019. However, if it is not supported then I can use the Virtual Service Account but how do I configure it to stop giving this error message? The account is mapped to the ReportServer database.
I will appreciate some help please. Thank you.