SSRS Web Service URL - getting rid of HTTP

  • Not sure if this is the place to ask, but will give it a shot.

    We have an instance of SSRS 2019 running, and we connect to it via our Dynamics CRM (online version) - in this case via an IFRAME within a form.  The report works, the issue is that some of the images in the report do not render, the reason being that we're calling the report via HTTPS, but the SSRS Web Service is configured for both HTTP and HTTPS, and it's defaulting to HTTP.  And since the result that comes back is mixed, it's refusing to render the images.

    A solution I've found is to go into the SSRS Configuration tool and under the Web Service URL, remove the URL for HTTP.  However, when I do this, the "Report Server Web Service Site Identification" panel goes blank, and is greyed out.  I had assumed it would default to the remaining URL but that does not appear to be the case.

    Does anyone know how to get rid of the HTTP URL and have it use the HTTPS?

  • Store the images in a different location. Don't embed them into the report.

    Create an images folder on the SSRS box, and point the report to the image there.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Unfortunately some of the images in question are not our images - for example the little arrows that show that you can sort a column aren't rendering.  Those are embedded automatically by SSRS, and the report is linking to them via HTTP.

     

  • cphite wrote:

    Unfortunately some of the images in question are not our images - for example the little arrows that show that you can sort a column aren't rendering.  Those are embedded automatically by SSRS, and the report is linking to them via HTTP.

    I know this, but I don't remember it!!!  It's been a while since I supported SSRS.

    If I remember, when we updated, we had a similar issue.  There were images like the logos of our clients that were displayed on the various reports.  The ones that were embedded into the report stopped rendering.  The ones that were stored in an "Image" folder created in SSRS rendered, but very slowly.   By trial and error, one of the devs created a folder on the drive of the SSRS servers, put the images in that, and it solved the issue.  It was a lot of work changing these reports.

    Aren't there places in the two SSRS configuration files that can be modified for the HTTP/HTTPS?

    https://learn.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-configuration-files?view=sql-server-ver16

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply