I've been dealing with a similar problem for the last few days,
specifically since I upgraded to CM12 R2.
I get the following error when I try to launch any reports:
* The DefaultValue expression for the report parameter 'UserTokenSIDs'
contains an error: Logon failure: unknown user name or bad password.
(rsRuntimeErrorInExpression)
-Harjit
On 10/30/2013 7:59 PM, Roland Janus wrote:
I get this when I add SSRS using a PS cmdlet. Although the password
(encrypted) is accepted, somehow it isn't working (there are issues
with other cmdlets also).
What I do is to re-enter the account (using "new account") in the
role, but provide the same account and passwords.
Then you have to wait. In the ssrs.log, it says "setting security at
xx:xx:xx". Once it did that it actually worked.
Also if the reporting account doesn't show up as a sql-login, it also
doesn't work.
You did add the reporting account to have "log on interactive" access
in the local policy, right?
-Roland
*From:*[email protected]
[mailto:[email protected]] *On Behalf Of *Murray, Mike
*Sent:* Mittwoch, 30. Oktober 2013 21:36
*To:* [email protected]
*Subject:* [mssms] Intermittent SSRS authentication issues
I get this error intermittently when running reports in CM2012:
* An error has occurred during report processing. (rsProcessingAborted)
o Cannot impersonate user for data source
'AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_'.
(rsErrorImpersonatingUser)
+ Log on failed. Ensure the user name and password are
correct. (rsLogonFailed)
For more information about this error navigate to the report server on
the local server machine, or enable remote errors
I checked permissions, they are fine. I even tried this fix, no luck.
http://waveformation.com/2011/03/31/error-deploying-lync-2010-monitoring-reports/
The reports run fine at times, then a little later I get the error.
Ideas?
Best Regards,
Mike Murray
Desktop Management Coordinator - IT Support Services
California State University, Chico
530.898.4357
[email protected] <mailto:[email protected]>
