SQL Server Reporting Services 2012 anonymous access

Posted on March 28, 2012 by Constantin Rotariu

Disclaimer:
ANONYMOUS AUTHENTICATION or ACCESS for SQL Server Reporting Services 2012 IS NOT OFFICIAL SUPPORTED SO DON’T USE IT IN PRODUCTION ENVIRONMENT!
But in case you still want to try it here are the steps:
Step 1: Change authentication types in “C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config” to :
From:

   
    
      
    
    Off
    Proxy
    true
  

To:

  
    
      
    
    Off
    Proxy
    true
  

Step 2: Set authentication mode to “None” and identity impersonate to “false” in “C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\web.config”
From:

To:

Step 3:  Set authentication mode to “None” and identity impersonate to “false” in “C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportManager\web.config”
From:

To:

Step 4: Download Microsoft.Samples.ReportingServices.AnonymousSecurity.dll and drop the file into “C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\bin” directory:
Note: I used the code provided on this Microsoft blog
Or you can download complete C# project (you can find the dll file in: Microsoft.Samples.ReportingServices.AnonymousSecurity\bin\release)
Step 5: Change Extension Name in “C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config”:
From:

To:

Step 6: Add the following CodeGroup between

  into “C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rssrvpolicy.config”

From:

                                                                            To:

                                                                                                                                                               Last Step: Restart the Reporting Services 2012 server and your server is anonymous

The following are the steps to compile the .dll in case you want to do that but you don’t know how:
Get the code from the following class
Microsoft.Samples.ReportingServices.AnonymousSecurity\Class1.cs in C# project or from the original source: Microsoft blog
1) Download and instal Visual C# 2010 Express :
http://www.microsoft.com/visualstudio/en-us/products/2010-editions/visual-csharp-express
2) Create a class library project named Microsoft.Samples.ReportingServices.AnonymousSecurity

3) From Solution Explorer, right click References directory to add Microsoft.ReportingServices.Interfaces reference from “C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\bin”
4) Change the framework from .Net 4 to .Net 2.0
From Solution Explorer, right click on Microsoft.Samples.ReportingServices.AnonymousSecurity and choose properties.

This entry was posted in SSRS and tagged anonymous access, anonymous authentication, reporting services, sql server 2012 by Constantin Rotariu. Bookmark the permalink.