Enabling password free access of SQL Server Reporting Services 2022

Copper Contributor

I've set up and configured the most recent release of SQL Server Reporting Services 2022 successfully. While it's functioning well, I need to make it accessible to the public without requiring a password. Despite attempting various methods found on Google or suggested by AI, it still prompts for a password. I acknowledge the security logic behind it, but it's essential for me to enable access without a password as per my requirement.01.png02.png

2 Replies

@arehman_2001 , by default SSRS supports Windows AD authentication and as any other server it has a permission system.

See Authentication with the report server - SQL Server Reporting Services (SSRS) | Microsoft Learn => "Anonymous" is not supported. You have to search for a customer auth solution = 3rd party

@arehman_2001 ,

I think you have an architecture problem.

Can you share what type of reports you need to show to all personnel in your organization?

SSRS is designed to support all company departments. Then there should be sections inside that are specific to some departments. If you disconnect the AD authentication from SSRS, Then all people can access all items. This is not correct form architectural aspect.

If you have a common section that should be accessed by all employees, Consider creating a folder inside SSRS, and give a A.D. group 'everyone' browse permission. Then anyone can access the SSRS portal in same way he login in to the operating system.