Facing slowness in SSRS report rendering with custom security implementation to support OIDC

TPP 0 Reputation points
2024-06-05T04:34:43.5733333+00:00

Our application uses SSRS reports with embedded XML Data source. Reports are having multiple sub reports and sub reports are added dynamically based on data. Reports are rendering correctly with Windows Authentication.

We have implemented SSRS Custom Security implementation to support OIDC authentication in Microsoft Reporting Services to support a new security requirement.  

With this we are setting "No Credentials" for data source but report rendering is taking too much time ( Data Retrieval time is increased by 40 times). Further checking AdditionalLogInfo from ReportServer DB logs we can see ConnectionOpenTime/DataRetreival is increased considerably.

User's image

Any suggestion on why DataRetreival/ConnectionOpenTime taking time with OIDC with same data/reports ?

 

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,052 questions
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,849 questions
0 comments No comments
{count} votes