asked on

Sccm Report manager

I am trying to update the password for the data source for the sccm reports. When I change the password and test connection it says everything is good. I type the password again and hit apply. Next I can run the reports find. About 30 seconds later the reports start failing again with the error.

An error has occurred during report processing. (rsProcessingAborted)
Cannot impersonate user for data source 'ID5C6358F24BB64a1bA16E8D96795D8602'. (rsErrorImpersonatingUser)
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
Logon failure: unknown user name or bad password

So the new password works for a little bit then it defaults back to the old one. Is there something I am missing?
I am updating this under http://server/Reports/ then click ConfigMgr_SES then click the only data source at the bottom.

Thanks
fixitben

Jason clark

The error message "Logon failed for the unintended execution account" you are getting this because an Unintended Execution Account become outdated in Reporting Services Configuration. After the setting of username & password for the unintended execution account that were updated to the current working credentials, the report ran without issue. To know more please go this one https://msdn.microsoft.com/en-us/library/ms156302.aspx

fixitben

ASKER

HI Jason,

I had tried updating the execution account under the "reporting services configuration" before posting this. It didn't make a difference. The only place I get it to work temporarily is the image below.

If I update it here it works for around 30second to a minute then reverts back. If I update it "reporting services configuration" it does nothing.

I could delete the data source and recreate it, but I am afraid the cascading permissions of the reports won't follow or it will break.

Thanks

ASKER CERTIFIED SOLUTION

fixitben

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial