question

MarekG-1989 avatar image
0 Votes"
MarekG-1989 asked MarekG-1989 answered

SCOM 2022 SSRS

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

msc-operations-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SimonRenMSFT-3639 avatar image
0 Votes"
SimonRenMSFT-3639 answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MarekG-1989 avatar image
0 Votes"
MarekG-1989 answered

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....

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SimonRenMSFT-3639 avatar image
0 Votes"
SimonRenMSFT-3639 answered

Hi @MarekG-1989,

Thanks for your reply.

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

198443-execution.png

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.



execution.png (64.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MarekG-1989 avatar image
0 Votes"
MarekG-1989 answered

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)....

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.