That is a good question! Im not able too verify that until tomorrow, but it worked before the upgrade to R2 (Sp1 cu2) with the current setup with or without SPN's..
Regards Mattias Benninge http://myitforum.com/cs2/blogs/matbe/default.aspx On Thu, Oct 31, 2013 at 7:47 PM, <[email protected]> wrote: > Do you have SPNs defined for your CM SQL Server?**** > > ** ** > > Resetting the SSRS permissions will probably not help this scenario.**** > > ** ** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Mattias Benninge > *Sent:* Thursday, October 31, 2013 12:26 PM > > *To:* [email protected] > *Subject:* Re: [mssms] Intermittent SSRS authentication issues**** > > ** ** > > 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]**** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > **** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > >
