Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

reporting services anonymous access to reports

Tags:

I can't create a NT account for everyone that need access to the reports. Does anyone know or have a link to the info to allow anonymous access to reporting services reports ?

Thanks

like image 394
freddoo Avatar asked Dec 10 '08 20:12

freddoo


People also ask

How do I enable anonymous access in SSRS?

Standard install of SSRS 2005 (Integrated authentication) In IIS, duplicate the ReportingServices virtual directory and name it Public. Under Public properties set Directory Security - Authentication and Access Control - to Enable Anonymous access using the IUSR_ account. Uncheck all other access types.

How do I grant access to a report server?

To delegate this task to other users, create role assignments that map user accounts to Content Manager and System Administrator roles. Users who have Content Manager and System Administrator permissions can add users to a report server.

How do I access Reporting Services?

Click Start, then click All Programs, then click Microsoft SQL Server, and then click SQL Server Management Studio. The Connect to Server dialog box appears. If the Connect to Server dialog box doesn't appear, in Object Explorer, click Connect and then select Reporting Services.


1 Answers

Thanks, I had tried it before but was failing, tried again and worked fine, must have missed something the first time around.

The steps are very simple:

  1. Standard install of SSRS 2005 (Integrated authentication)
  2. In IIS, duplicate the ReportingServices virtual directory and name it Public
  3. Under Public properties set Directory Security - Authentication and Access Control - to Enable Anonymous access using the IUSR_ account. Uncheck all other access types.
  4. Using the report manager, set up a folder named Public, and added the IUSR_ account to the Public directory role manager with a viewonly role. (Assuming you have already established a viewonly role as one with only the 'view reports' task enabled.)
  5. Add any other types of administrative/developer accounts
like image 68
freddoo Avatar answered Sep 30 '22 18:09

freddoo