SCOM 2022 SSRS

Question

Hi all
after clean install SCOM 2022 and SSRS the reports not work correctly. In report server configuration manager is after install execution account same service account. It is gsma account . But every report now return errror: The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
The user name or password is incorrect. After i change this to nedef
The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)....
which account is needed this ?
thanx

Answer 1

Hi,

Thanks for posting in Microsoft MECM Q&A forum.

Are you using the gsma Data Reader account (for SSRS)? If yes, please make sure it is a member of Operations Manager Report Security Administrators group. And also verify if the managed service account can be used on the management server you selected.

Refer to the official article: Support for group managed service accounts

Hope it helps. Thanks for your time.

Best regards,
Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thank you for answer,
i look to requirement for gSMA and all is ok... Account which run SSRS is in group Operations Manager Report Security Administrator. Reports work but some report want execution account , some not. But if set why return "Log on failed. Ensure the user name and password are correct. (rsLogonFailed)" gSMA account have password in AD....

Answer 3

Hi @Marek G ,

Thanks for your reply.

Have you ever configured the Execution Account in Report Server Configuration Manager? For example:

Refer to:
The report server has encountered a configuration error. Logon failed for the unattended execution account.
Configure the Unattended Execution Account (Report Server Configuration Manager)

Hope it helps. Thanks for your time.

Best regards,
Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

Yes there I have gSMA domain\account$ and reports return
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
The user name or password is incorrect.
After i change this to nedef
The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)....

Answer 5

I have the same issue in SCOM 2019 UR5. I confirmed that the the account is not disabled. Note that the SSRS Execution account cannot be a gMSA. I am using a standard account for the Execution account.

Advise from Microsoft is that the SSRS Execution account needs the same SQL permissions as the SCOM Data Reader account. SSRS advises to have limited permissions for the Execution account so it is confusing.