A thought MAYBE... as a user with rights to do anything/everything, if you go to yourserver/reports, then Details View... look for the DataSource definitions. In my lab that happens to be under ConfigMgr_XYZ folder, at the bottom in detail view.
If you have multiple; like one for CM12 and one for CM07... (well, first take screen shots or otherwise save the cm07 datasource details) then make the one that points to your CM07 datasource... look exactly like your CM12 datasource.-- the datasource you KNOW works. Specifically the connection string / credentials. Sherry Kissinger Microsoft MVP - ConfigMgr [email protected] ________________________________ From: Roland Janus <[email protected]> To: [email protected] Sent: Wednesday, November 13, 2013 4:58 PM Subject: RE: [mssms] Intermittent SSRS authentication issues Nope, to specific. I only had the issue, and the solution, with a newly installed CM12, nothing migrated. From:[email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Mittwoch, 13. November 2013 22:20 To: [email protected] Subject: RE: [mssms] Intermittent SSRS authentication issues I think I’ve narrowed this down a bit. All the reports that were built in, or were transferred over from CM07 have this issue. A report I recently created from scratch using the “Use current Windows user” under credentials in the data source run fine. Sheesh, the last thing I want to do is go through all these reports and set up a new data source. Any ideas? From:[email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Tuesday, November 12, 2013 4:31 PM To: [email protected] Subject: RE: [mssms] Intermittent SSRS authentication issues We have a single primary site, SSRS is on another server (our SQL server). It comes and goes. Works one minute, can’t access the next. From:[email protected] [mailto:[email protected]] On Behalf Of Roland Janus Sent: Tuesday, November 12, 2013 4:25 PM To: [email protected] Subject: RE: [mssms] Intermittent SSRS authentication issues Well, you obviously have something specific broken, or getting broken later, from what you wrote. You have only one SSRS? No lab, what about a single primary to test? They are rather easy to install. From:[email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Mittwoch, 13. November 2013 00:17 To: [email protected] Subject: RE: [mssms] Intermittent SSRS authentication issues No, I checked that. From:[email protected] [mailto:[email protected]] On Behalf Of Roland Janus Sent: Saturday, November 09, 2013 4:10 AM To: [email protected] Subject: RE: [mssms] Intermittent SSRS authentication issues Maybe you have a pre-req problem? From:[email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Freitag, 8. November 2013 22:59 To: [email protected] Subject: RE: [mssms] Intermittent SSRS authentication issues bump From:[email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Wednesday, November 06, 2013 10:19 AM To: [email protected] Subject: RE: [mssms] Intermittent SSRS authentication issues Tried this suggestion, still no luck. Any other ideas? From:[email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Monday, November 04, 2013 12:28 PM 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:[email protected][mailto:[email protected]] On Behalf Of Murray, Mike Sent: Wednesday, October 30, 2013 4:36 PM 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]
