SSRS - report viewer web part - Sharepoint 2019

Rumi 156 Reputation points
2021-03-03T22:16:06.7+00:00

Hello,

I'm using SSRS 2017 native mode and we'd like to use the report viewer web part to display reports in SharePoint 2019 (classic page), is it necessary to configure Claims to Windows token service for this?

Thank you,

Rumi

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,227 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,806 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. JoyZ 18,041 Reputation points
    2021-03-04T07:03:41.06+00:00

    Hi @Rumi ,

    Quote from Microsoft:

    The SharePoint Claims to Windows Token Service (C2WTS) is required if you want to view native mode reports within the SQL Server Reporting Services Report Viewer web part.

    C2WTS is also required with SQL Server Reporting Services SharePoint mode if you want to use Windows authentication for data sources that are outside the SharePoint farm.

    More information for your reference:

    https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/claims-to-windows-token-service-c2wts-and-reporting-services?view=sql-server-ver15

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.