Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  How to set up security on RS?

Author  Topic  pmak Starting Member 41 Posts Posted - 2006-05-12 : 19:47:24 I need to set up the security on the Reporting Services such that user can view the reports ONLY through a ReportViewer control on a asp.net web page i.e. not allow to navigate all other folders or areas in the Report Manager. Reporting services is installed on a stand alone server (not belong to any domain, no AD set up) running on Windows 2003 server. Currently I configured the "Report Manager" and "ReportServer" web site to allow annonyous access. However some users know how to bypass the web application and directly enter the IP address/reports of the stand alone server to view all the reports. The asp.net page has built-in Sql security to filter out the reports listed on the page based on the user login and password. This web application is also hosted at the stand alone server and is connected to a remote Sql server. The entire web application is using the sql security.