SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,799 questions
Facing slowness in SSRS report rendering with custom security implementation to support OIDC
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 53%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TPP
0
Reputation points
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.
Any suggestion on why DataRetreival/ConnectionOpenTime taking time with OIDC with same data/reports ?
Sign in to answer