I got the same error as Harjit: The DefaultValue expression for the report parameter ‘UserTokenSIDs’ contains an error: Logon failure: unknown user name or bad password. (rsRuntimeErrorInExpression)
Se my post from earlier today below: --- 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 http://myitforum.com/cs2/blogs/matbe/default.aspx On Thu, Oct 31, 2013 at 7:11 PM, Harjit Dhaliwal <[email protected]> wrote: > How about for both? I have re-installed the Reporting point role too and > no luck. > Thanks. > > -Harjit > > > On 10/31/2013 2:05 PM, Garth Jones wrote: > > For which error are you talking about, there are two completely > different errors listed below? **** > > ** ** > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] *On > Behalf Of *Mattias Benninge > *Sent:* Thursday, October 31, 2013 1:54 PM > > *To:* [email protected] > *Subject:* Re: [mssms] Intermittent SSRS authentication issues**** > > ** ** > > I have tried to re-install the Reporting Point Role but it did not work, > how do you reset the SSRS permissions?**** > > > **** > > Regards**** > > Mattias Benninge**** > > http://myitforum.com/cs2/blogs/matbe/default.aspx**** > > **** > > ** ** > > On Thu, Oct 31, 2013 at 1:26 PM, Garth Jones <[email protected]> wrote:* > *** > > Hi Harjit, but you error is not the same at Mike, What others have done in > this situation is re-install the Reporting Point or reset the SSRS > permission. **** > > **** > > **** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Harjit Dhaliwal > *Sent:* Wednesday, October 30, 2013 9:11 PM > *To:* [email protected] > *Subject:* Re: [mssms] Intermittent SSRS authentication issues**** > > **** > > 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]**** > > **** > > **** > > **** > > **** > > **** > > ** ** > > ** ** > > ** ** > > > >
