none
Report Builder Custom HTTPS Port RRS feed

  • Question

  • Hi all,

    I have an issue with Report Builder using a custom port number with HTTPS for my report server. I can connect to Report Server from Report Builder, I can open and save reports, but when I try running a report from Report Builder, it sends the request to port 443 instead of my custom port resulting in a 401 unauthorized. 

    I know it tries to hit my server on port 443 because I see it in my IIS log:

    POST /ReportServer/ReportExecution2005.asmx - 443

    Is this a bug in Report Builder or is there a way to tell Report Builder to use a certain URL for any request including the requests to ReportExecution2005.asmx service?

    Thanks

    Tuesday, August 20, 2019 5:22 PM

Answers

  • Hi Skweda,

    Were you trying to open report with report builder directly in RS Web Portal(HTTPS)?

    If so, it's a known issue, that with https and not default port, we would encounter this kind of issue. 

    We suggest you to use 443 port as it is already secured link to work around this, or use open report in Report Builder to choose the report.

      

    If you insist your original request, I suggest you submit the requirement at https://feedback.azure.com/forums/908035-sql-server.

    If the requirement mentioned by customers for many times, the product team may consider to add this feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided.

    Best Regards,

    Lukas

     

    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, August 21, 2019 1:36 AM
  • Hi Lukas,

    Thanks for your quick reply. I tried both opening a report via Report Manager and opening Report Builder, connecting to RS and opening a report within Report Builder. Both scenarios have the same issue, when trying to view the report, the request is sent to port 443 regardless of the port entered when connecting to RS.

    I will submit a requirement as you suggested. In the meantime, I overcame the situation by adding a second external IP address to my VM and configuring RS to use port 443 on this second IP address.

    Wednesday, August 21, 2019 1:35 PM

All replies

  • Hi Skweda,

    Were you trying to open report with report builder directly in RS Web Portal(HTTPS)?

    If so, it's a known issue, that with https and not default port, we would encounter this kind of issue. 

    We suggest you to use 443 port as it is already secured link to work around this, or use open report in Report Builder to choose the report.

      

    If you insist your original request, I suggest you submit the requirement at https://feedback.azure.com/forums/908035-sql-server.

    If the requirement mentioned by customers for many times, the product team may consider to add this feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided.

    Best Regards,

    Lukas

     

    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, August 21, 2019 1:36 AM
  • Hi Lukas,

    Thanks for your quick reply. I tried both opening a report via Report Manager and opening Report Builder, connecting to RS and opening a report within Report Builder. Both scenarios have the same issue, when trying to view the report, the request is sent to port 443 regardless of the port entered when connecting to RS.

    I will submit a requirement as you suggested. In the meantime, I overcame the situation by adding a second external IP address to my VM and configuring RS to use port 443 on this second IP address.

    Wednesday, August 21, 2019 1:35 PM
  • Hi 

    I have two SSRS VMs and I noticed the same issue on only one server

    Configuration: Windows Server, SSRS on http is on port 80, https is on port 4443 (and NOT 443).

    Report Manager, Report Service works fine on both http and https. Report Builder works fine on http (i.e., default port 80)

    Report Builder is NOT working on https - custom port "4443". 

    Weird is that it is working on other VM and not on one VM. Any steps or idea how to resolve this?

    thanks

    Sree


    Vankayala S

    Wednesday, September 11, 2019 3:41 AM