Groups | Blog | Home
all groups > sql server reporting services > march 2007 >

sql server reporting services : accessing reports securely through ASP


jknurek
3/14/2007 12:27:03 PM
Hej
I'm new to Reporting Services. I'm using RS 2005, ASP 2.0 and VS 2003.
I've created the reports and have been using a URL link in my ASP site to
ReportServer/Pages/ReportViewer.aspx?%2fFOLDER%2fREPORT for viewing the
reports. When the reports are accessed outside the server, the browser
requires username and password. This isn't desired.

Whats the best way to handle this? If I switch to VS 2005 does the
ReportViewer control handle this? Is it possible/safe to change the user
rights for ReportViewer.aspx? Its important not to allow users access to the
Report Manager, but can the rights to viewing individual reports be handled
through there?

EMartinez
3/14/2007 12:46:08 PM
[quoted text, click to view]

I believe that there is a way to control (minimally) access to reports
in the Report Manager interface (check the top right-hand side of the
main page). Also you can control user access through the application
(as far as, not showing the user a link to the Report Server, etc).
Sometimes the login is required when the user accesses the Report
Server from Mozilla or Firefox (whereas, w/Internet WExplorer, it may
not happen). Also, you can check the Directory Security for the
Reports and Report Server Virtual Directories in IIS to check for
Windows Authentication, anonymous access, etc (via right-clicking My
Computer, select 'Manage' and go to Services and Applications ->
Internet Information Services -> Web Sites -> Default Web and right-
clicking the Reports or ReportServer Virtual Directory and selecting
Properties and the 'Directory Security' tab). Hope this helps.

Regards,

Enrique Martinez
Sr. SQL Server Developer
AddThis Social Bookmark Button