Accessing reports from web application
Hi All, I am aware that we can access the reports from the webapp using the report viewer component.Also I know that the users and groups can be added through site setting and folder setting's new role assignment for giving access to the reports.I am using SQL Server 2008 R2.But I have some doubts which are as follows:- What is the best practice to to view report through front end if the users are given role based access security through custom webapp.How will each user get the limited access to the reports.How can I control that? How will I able to give access to the domain users to view reports? How will the credential factor be taken care off?Else it will give http 401 unauthorised error. What should be the authentication mode for above two scenarios?RSWindowsNTLM or any other? I would definitely appreciate your help.Thanks in advance. Thanks and Regards, Franco Lopes. Ask a Question and you are fool for a second but if don't ask a question you are fool forever.
January 21st, 2011 1:38pm

Hi, "1.What is the best practice to to view report through front end if the users are given role based access security through custom webapp.How will each user get the limited access to the reports.How can I control that? " Since you have setup the users role securty in the report server, the RSWindowsNTLM is the choice. "2.How will I able to give access to the domain users to view reports? How will the credential factor be taken care off?Else it will give http 401 unauthorised error. 3.What should be the authentication mode for above two scenarios?RSWindowsNTLM or any other? " Enable Kerberos authentication, otherwise, the double hop issue will occur(the 401 error might be caused because of this). RSWindowsNTLM authentication mode as previously answered. check http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/2b28272c-e668-41c9-80ce-af4d6eadca61 for within the similar situation. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
January 24th, 2011 3:48am

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

Other recent topics Other recent topics