Dynamics Community Forum Thread Details

SSRS Required Ports

I have a site using SSRS and migrating from GP2018 to GP18.5.

SSRS is used in Native mode and we successfully transitioned it into SQL 2019. It works well on the server where it is installed, but I am having problems accessing it from a workstation. If I disable the server's the workstation will function, however I'd rather not disable the firewall. If I leave the firewall on and open ports 1433, 1434, the workstation remains blocked. Is there another port that needs to be opened? Or something else I may be missing?

Please advise. Thank you.

Categories:

Microsoft Dynamics GP

Dynamics GP doesn't use anything unique for SQL Reporting Services reports, it's only deploying onto the /reports and /reportserver sites that already exist.

So, the ports are usually HTTP 80, HTTPS 443 and then ports 1433 and 1434 that SQL Server uses, that's about it.

I'm curious if you have SQL Server and Reporting Services installed on two different servers? The reason I ask is, when you have that type of configuration, instead of SQL and SSRS on the same server, when trying to access the reports from a third machine, we see issues, where the reports work fine on either of those two servers.

The issue, in that case, is a limitation of the Windows authentication and the number of hops it can make, and the need for Kerberos authentication or some other type of configuration.

Thanks

Quick Links

Leaderboard