SQL Server 2008 R2 unable to grant access to user so they can view reports.
I hope someone can help here and I thank you in advance. I can create and Delploy my SSRS R2 reports and I can view them. the problem is anyone else who tries to veiw them gets a login and then a blank screen. I have create an Active Directory group and put the people in there and assigned them brower role at the Report manager page. I also added the Active Directory group to my SQL server. Yet no one can view my reports. I am not using Sharepoint just my local machine as the host. it is has a XP OP. Please help, i dont know what I am missing and I need to get these reports in production. also here is what my config file looks like for authentication. < AuthenticationTypes > < RSWindowsNTLM /> < RSWindowsNegotiate /> < RswindowsKERBOS /> </ AuthenticationTypes > THank you
November 11th, 2011 2:16pm

Hi js34259, Have you configured the firewall for Report Server Access:http://msdn.microsoft.com/en-us/library/bb934283.aspx ? Make sure that your site is added to the Trusted Sites zone as described in this similar thread: http://social.msdn.microsoft.com/Forums/ar-SA/sqlreportingservices/thread/fffa4d0d-6cc9-4385-8a30-8a1b8243f619 If either of them above do help, please assign the browser permission for some users in the AD group individually to Report Manager site and some specific folder: http://msdn.microsoft.com/en-us/library/aa337491.aspx Thanks, Lola Please remember to mark the replies as answers if they help.
Free Windows Admin Tool Kit Click here and download it now
November 14th, 2011 9:12pm

Hi js34259, Have you configured the firewall for Report Server Access:http://msdn.microsoft.com/en-us/library/bb934283.aspx ? Make sure that your site is added to the Trusted Sites zone as described in this similar thread: http://social.msdn.microsoft.com/Forums/ar-SA/sqlreportingservices/thread/fffa4d0d-6cc9-4385-8a30-8a1b8243f619 If either of them above do help, please assign the browser permission for some users in the AD group individually to Report Manager site and some specific folder: http://msdn.microsoft.com/en-us/library/aa337491.aspx Thanks, Lola Please remember to mark the replies as answers if they help.
November 15th, 2011 5:08am

Worked like a charm! Thank youJeff
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2011 9:58am

Lola, thanks for your help. I hope you can help me one more time. I can now get an AD with some user access to my reports thanks to you, but now I need about 250 people to view this report. how do I set this up so I do not have to enter all these people manually? THanks again for your help. js34259Jeff
November 17th, 2011 3:04pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics