Forum Discussion

arehman_2001's avatar
arehman_2001
Copper Contributor
Apr 05, 2024

Enabling password free access of SQL Server Reporting Services 2022

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.

  • ADardeer's avatar
    ADardeer
    Copper Contributor

    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.

Resources