I have the exact same issue after upgrading to R2, I have an active case with Microsoft on this and they been working for 5 days on it without any progress. I have tried changing accounts and everything else recommended here but no success. I even get the same error if I use a "Fake" account. After turning on the security logs in SQL I can never see that the SSRS account even tries to contact the SQL server since i dont get neither a failed or successful logon. I have Sitesystem + SQL on one server and then I have SSRS on a separate server, on my lab where I have SSRS on the same server it works as expected.
Regards Mattias Benninge On Thu, Oct 31, 2013 at 2:10 AM, Harjit Dhaliwal <[email protected]> wrote: > 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] <[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) **** > - 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]**** > > ** ** > > ** ** > > > >
