Sorry for the delay.timezones.
Ok so the site is trusted and I've tried using it's FQDN I have looked at the security in the CM console and it looks ok to me. The issue is strange because a user that can access the reports in the console can't access the reports via the web interface, in fact, I have not been able to find a user to authenticate with - no user is accepted. In addition, any user besides the user that can see the reports in the console (which is the user I used to install and configure everything) cannot view any reports in the console. Hope that makes some sort of sense. From: [email protected] [mailto:[email protected]] On Behalf Of Dzikowski, Michael Sent: Wednesday, 3 July 2013 11:44 PM To: [email protected] Subject: RE: [mssms] Permission issue accessing reports You probably already did this but, what about the permissions here in SSRS: From: <mailto:[email protected]> [email protected] [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Garth Jones Sent: Wednesday, July 03, 2013 9:00 AM To: <mailto:[email protected]> [email protected] Subject: RE: [mssms] Permission issue accessing reports Is that after adding the site to the trusted sites within IE too? Do you have GPO setting to control IE? What do you mean by "all other users are unable to access reports through the console", can we assume that you have granted them access to the reports within CM12? Can they access everything else within the console? From: <mailto:[email protected]> [email protected] [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Daniel Corkill Sent: Wednesday, July 3, 2013 7:26 AM To: <mailto:[email protected]> [email protected] Subject: RE: [mssms] Permission issue accessing reports Still no go using the FQDN. It's the same result whether accessing it from the site server or remotely. From: <mailto:[email protected]> [email protected] [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Garth Jones Sent: Wednesday, 3 July 2013 8:44 PM To: <mailto:[email protected]> [email protected] Subject: RE: [mssms] Permission issue accessing reports Is this one the site server or from a remote PCs? Have you added the FQDN into the Trusted Site within IE? From: <mailto:[email protected]> [email protected] [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Daniel Corkill Sent: Tuesday, July 2, 2013 11:31 PM To: <mailto:[email protected]> [email protected] Subject: [mssms] Permission issue accessing reports Got a drama with reporting that I'm not able to resolve. When trying to access the reports through a browser, I'm getting prompted to authenticate and I cannot provide a user that is accepted. If I run the console as the user I used to install and configure ConfigMgr/SQL/SSRS I can run reports through the console; all other users are unable to access reports through the console. A final twist on the issue, the aforementioned user that can access the reports through the console is not able to access the reports through the browser. Any suggestions would be greatly appreciated. Daniel.
<<image002.jpg>>
