Share via

Does SQL Server Reporting Services Report Builder application support forms authentication to SSRS?

PaulGibson-6972 21 Reputation points
2025-02-13T17:29:57.4266667+00:00

I have configured my SQL Server Reporting Services server to use Forms authentication to work with a custom SSO identity provider. The web experience works fine, but the Report Builder client application is not able to connect. Is there documentation clarifying if Report Builder will work when Forms authentication is used with SSRS?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,996 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 40,661 Reputation points
    2025-02-14T06:06:52.82+00:00

    Hi @PaulGibson-6972,

    Per my research, i have not found the official documentation clarifying if Report Builder will work when Forms authentication is used with SSRS.

    Report Builder accepts unauthenticated requests if you enable Report Builder access on a report server configured for Basic authentication. For all other cases, anonymous requests are rejected with an HTTP Status 401 Access Denied error before the request reaches ASP.NET. Clients that receive 401 Access Denied must reformulate the request with a valid authentication type.

    Authentication in a report server

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.