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?
Asked
Active
Viewed 1,015 times
2
Mike
- 1,261
- 5
- 18
- 31
-
Has the SSRS server been granted access to read the gMSA, and the gMSA installed on the server? – SamErde Jun 04 '19 at 13:41
-
Yes, I already use the same gMSA for other services on the same server. – Mike Jun 05 '19 at 14:36
-
Is the actual source of data on a different server, or is it located on the same server? If the source data is on a different server, that other server will need to be granted permission to authenticate the gMSA as well. – SamErde Jun 06 '19 at 16:02
-
Yes, both servers have access to the gMSA. – Mike Jun 07 '19 at 19:34