rsCannotValidateEncryptedData

Question

rsCannotValidateEncryptedData

Patrick Kryzsko 6

SSRS user, AD domain function account, is configured and was previously working. SSRS 2016 runs on app server and uses SQL backend, ver. 2012 to store report server database and tempdb. Web app interacts by launching reports from a ver. 2016 web server which uses a functional account. Recently password length was increased from min. 8 - 25 charachter; password was not changed. Since password length setting was increased, the domain web functional account is no longer able to communicate with SSRS, receiving error: rsCannotValidateEncryptedData.

Password was updated to new 25 charachter standard and new password was backed up and encrypted within SSRS configuration. Still receiving error.

Based on other research, I will run the procedure to remove encrypted data from the SQL back-end and then re-boot app server. I will update this question with results after running the procedure.

Patrick Kryzsko 6 Reputation points

2020-10-21T15:50:02.51+00:00

I've honed in on a table in the ReportServer db. The date the password policy was changed from min. 8 to min. 25, is the last time there were full records reported on the table named: ExecutionLogStorage I did not change the password on that date but is seems when the new policy was applied, it somehow broke the communication.
Patrick Kryzsko 6 Reputation points

2020-10-21T17:36:45.677+00:00

Looks like I solved this. After the password change, I should have done the "Change" in SSRS Configuration (3rd option). I then had to go into the ReportServer and re-add the connection string and credentials.

1 answer

Your answer

Patrick Kryzsko 6 Reputation points

2020-10-21T15:50:02.51+00:00

I've honed in on a table in the ReportServer db. The date the password policy was changed from min. 8 to min. 25, is the last time there were full records reported on the table named: ExecutionLogStorage I did not change the password on that date but is seems when the new policy was applied, it somehow broke the communication.
Patrick Kryzsko 6 Reputation points

2020-10-21T17:36:45.677+00:00

Looks like I solved this. After the password change, I should have done the "Change" in SSRS Configuration (3rd option). I then had to go into the ReportServer and re-add the connection string and credentials.

Answer 1

ZoeHui-MSFT 41,491

Hi @Patrick Kryzsko ,

Glad to hear you have resolved the issue.

You may reply the resolution and click "Accept Answer" so that we could achieve the case.

Regards，

Zoe

If the answer 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.

ZoeHui-MSFT 41,491 Reputation points

2020-10-23T05:44:14.257+00:00

Hi @Patrick Kryzsko ，nice day! please click "Accept Answer" so that we could achieve the case.

Share via

rsCannotValidateEncryptedData

1 answer

Your answer