ANONYMOUS LOGINS TO SSRS

Here are some notes I have collected to open up SSRS for anonymous logins and the errors you may see

Stored Credentials and Anonymous Logons and Browsing in Reporting Services Does not work rsAccessDenied   rsErrorOpeningConnection

The permissions granted to user are insufficient for performing this operation. (rsAccessDenied)

rsErrorOpeningConnection Windows NT user does not have server access.

1.       Folder Security

a.        Open up report manager >> home .>> Folder Settings

b.       Add BUILTIN\Users as BROWSER ROLE

c.        Add BUILTIN\IIS_IUSRS as BROWSER ROLE

d.       Apply

2.       Store Credentials (do for each datasource)

a.        Open Report Manager >> Home >> Datasources

b.       Click on the datasource

c.        Add the credentials to the database under “Credentials stored securely in the report server”

d.       Do not check the other two boxes.  ** Unless using domain account ??

e.       Apply

3.       Reporting Services Service Account

a.        Open reporting services configuration manager

b.       Click Service Account

                                                               i.      Make note of the account used.

c.        Click on Execution Account

                                                               i.      Make note of the account used

4.       Grant allow log on locally

a.        Administrator tools >> Local Security Policy

b.       Security Settings >> Local Policies >> user Rights Assignment

c.        Log on Locally

                                                               i.      Add the two accounts found above as grant.