Sharepoint 2019 Page Viewer Web Part and SSRS - connection refused

Pedro Soares 396 Reputation points

Im using Sharepoint Server 2019 and SSRS 2019 and I'm trying to user a Page Viewer web part to show a SSRS report embeded in a classic website. However, when I am using the server alias which hides the server real name (servername is an alias of servername-db1) to access the sharepoint URL, a gray area appears on the web part location with a lock saying that servername-db1 refused the connection IF I don't hide the toolbar with the rc:Toolbar=False command on the report server URL of the report. It works fine if I hide the toolbar.

Any idea on how to overcome this issue?

Thank you

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,234 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,377 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Jinwei Li-MSFT 4,701 Reputation points Microsoft Vendor

    Hi @Pedro Soares ,

    I have tested the issue like you said in my environment during these days. I am not able to reproduce this issue. In this scenario, I would suggest you open a ticket with Microsoft for further help.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.