Access to on prem reporting services 2019 path issues when coming through app proxy URL

Michael Michaud 1 Reputation point
2024-12-19T15:43:06.9333333+00:00

I have a on prem reporting site setup in ssrs 2019. when I access the site through an app proxy, we put the entire URL to /reports. we can successfully connect and display the main reporting pages fine, however when we try to open a report, its trying to reference a path thats /reportserver. Since the app proxy can only see the current folder and above, it cannot get to the /reports page. We have just the basic setup for the SSRS front end so im curious how we can remedy this situation. the only way we can do it currently is send them to the lower path and redirect them to the /reports which even that isn't working correctly.

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,960 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ketsha 240 Reputation points Microsoft Employee
    2024-12-19T16:37:07.59+00:00

    Hi Michael Michaud -

    You are experiencing a common issue with SSRS when using an application proxy. The problem arises because SSRS uses different virtual directories for the Report Manager (/reports) and the Report Server (/reportserver). Here are a few steps you can take to resolve this:

    1. Configure the Application Proxy

    Ensure that your application proxy is configured to handle both /reports and /reportserver paths. This might involve setting up rules or mappings in your proxy configuration to allow access to both paths.

    1. Modify the SSRS Configuration

    You can modify the SSRS configuration to use a single virtual directory. This involves changing the URLs in the SSRS Configuration Manager:

    1. Open SSRS Configuration Manager.
    2. Navigate to the Web Service URL and Web Portal URL sections.
    3. Set both URLs to use the same virtual directory. For example, you can set both to /reports.
    4. URL Rewriting

    If modifying the proxy or SSRS configuration is not feasible, you can use URL rewriting to redirect requests from /reportserver to /reports. This can be done using a reverse proxy like Nginx or Apache, or even within your application proxy if it supports URL rewriting.

    Example Configuration for Nginx:

    server
    
    1. Check SSRS Settings

    Ensure that the SSRS settings are correctly configured to use the appropriate URLs. You can verify this in the rsreportserver.config file located in the SSRS installation directory. Look for the <UrlRoot> element and ensure it points to the correct URL.

    0 comments No comments

  2. ZoeHui-MSFT 38,871 Reputation points
    2024-12-20T03:28:30.2866667+00:00

    Hi @Michael Michaud

    What about using Rest api to get the report and use it in the APP?

    REST APIs for Reporting Services

    Regards,

    Zoe Hui


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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.