Can I use a gMSA for stored credentials in a SSRS data source?

Question

I have an instance of SQL Server 2016 Reporting Services service running under DOMAIN\reporting$ containing a data source that needs to query a database using the stored credential DOMAIN\database$. Unfortunately when I store the gMSA credential and click Test Connection I get Log on failed. Ensure the user name and password are correct. It seems to work correctly if I use non-gMSA domain accounts. Is there any way I can use a gMSA as a stored credential in a SSRS data source?

Answer 1

"Probably?"

You can generally use the password _SA_{262E99C9-6160-4871-ACEC-4E61736B6F21} (SERVICE_ACCOUNT_PASSWORD / magnumdb) to utilize a gMSA where an AD account would otherwise work. Haven't checked with SSRS Data Sources in particular, but...