Anonymous Access to SSRS Report

Posted on

Question :

We’re looking to have a RaspberryPi run in kiosk mode and automatically pull up a report on our SSRS portal without any user interaction.

I’m hoping I can allow anonymous access to this specific report and keep Active Directory authentication in place for our other reports/folders.

I’ve added “NT AUTHORITYANONYMOUS LOGON” to the report security without any luck.

Is what I’m looking to do possible?

We’re running MSSQL 2019.

EDIT: Found a solution if anyone’s looking for a workaround. It’s an old article but works with PowerBi Reporting Services May 2021: https://tickett.wordpress.com/2014/12/03/anonymous-authentication-sql-server-reporting-services/?unapproved=9854&moderation-hash=4bf90332f3468fc8b78f6b84e1e63d6d#comment-9854

Answer :

You have to set up the custom authentication mode in SSRS configuration file.

This is the microsoft doc:

https://docs.microsoft.com/en-us/sql/reporting-services/security/authentication-with-the-report-server?view=sql-server-ver15

As you can see,

Anonymous authentication directs the report server to ignore
authentication header in an HTTP request. The report server accepts
all requests, but call on a custom ASP.NET Forms authentication that
you provide to authenticate the user.

Specify Custom only if you are deploying a custom authentication
module that handles all authentication requests on the report server.
You cannot use the Custom authentication type with the default Windows
Authentication extension.

Here you can fined how to configure it:

https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-custom-or-forms-authentication-on-the-report-server?view=sql-server-ver15

You can also find on github a good guide with examples:

https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample

Leave a Reply

Your email address will not be published. Required fields are marked *