Share via

Port number is being added to report viewer url in SSRS

Sadique Mankarathodi 0 Reputation points
2023-03-11T21:10:04.46+00:00

Hi All,

After migrating to a new server, We are facing issues in accessing SSRS reports in the report viewers.

While troubleshooting, we found that when we call the report in the browser using the following url, after authentication, we are redirected to another URL, in which the port number is also concatenated.

https://reports.domain.com/reportserver?%2fStaffing%2fMini_Report&rs:Command=Render

This will be redirected to the following URL 

https://reports.domain.com:8090/reportserverPages/ReportViewer.aspx?%2fStaffing%2fMini_Report&rs:Command=Render

On the report server side, The url is set as <ip>:8090/reportserver, and it is being masked with the domain name by the IT team(I've no idea about it).

This was working properly in the old server (SSRS version 14.0.600.1669).

But after migrating to the new server (SSRS version 14.0.601.20) and pointing the domain to the new IP, it is not working. When we click on a report in the web service URL, it also directs to the same url with the port number. The reports are loading correctly via Web Portal Url. If we enter the same url without port, the report is loading.

User's image

As it is a production instance, Any quick help is appreciated.

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,878 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2023-03-13T01:18:06.4033333+00:00

    Hi @Sadique Mankarathodi

    In general, port 80 is the default port on your computer for TCP/IP connections. Because the report server listens on port 80, you can ignore the port number in the URL. If you specify another port, you must specify that port in the URL.

    For more details, you can refer to this link: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/configure-report-server-urls-ssrs-configuration-manager?view=sql-server-ver16#default-urls.

    If my answer is helpful to you, please click "accept answer". If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments