To add to this, if that wasn't clear, I'm using the cmdlets, use the system-account for everything.
The service account has logon locally access. That's the one showing up in sql-logins after a while. Got it working local or remote to the DB -R From: [email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Montag, 4. November 2013 21:28 To: [email protected] Subject: RE: [mssms] Intermittent SSRS authentication issues Sorry, I was out Thursday and Friday. CM12 2008 They are on a separate box from the CM server, but both roles are on that server. All reports Hard to say. It will work, then not. Then I check back in an hour or two and it works again. I'm going to try Roland's suggestion below and see if that helps. 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. From: [email protected] [mailto:[email protected]] On Behalf Of Garth Jones Sent: Wednesday, October 30, 2013 2:16 PM To: [email protected] Subject: RE: [mssms] Intermittent SSRS authentication issues Hi Mike, . Is this for CM07 or CM12 . What version of SQL are you running? . Where is SQL ad SSRS are they on the same server? . Is this for all reports or just some reports? . For how long does this problem exist? From: <mailto:[email protected]> [email protected] [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Murray, Mike Sent: Wednesday, October 30, 2013 4:36 PM To: <mailto:[email protected]> [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-rep orts/ 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 <mailto:[email protected]> [email protected]
