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]**** > > **** > > **** > > ** ** > > ** ** > > ** ** > >
