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.
3,054 questions
Integrating PHP Web App with SSRS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 44%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Vijay Raghavan
0
Reputation points
Hi. I’m new to the SSRS Reporting Service. I’m on Windows Server 2022 and SQL Server 2019.. I have configured the Report Server Configuration Manager and in Web Service URL tab it shows an URL http://SEVRERNAME/ReportServer. When I hit the URL it asks for credentials first and I entered my Windows login credentials and it listed folders in there.
The problem I have is I have a PHP application hosted on IIS and I have a SSL certificate for my application. My application URL looks like https://custom.___domain.net and I have SSL cert for *.___domain.net Whereas I don’t have SSL cert for http://SERVERNAME/ReportServer. So I’m not able to hit the Report Server through HTTPS.
The task is to embed the Report Server in my PHP application. Tried the HTTP URL of Report Server and it throws errors in CSP. Added http://SERVERNAME in my CSP and now I have error for iframe stating that is a mixed content i.e Application is in https and it sends request to http.
What would be the proper solution for this? Should I get a SSL cert for SERVERNAME or is there any workaround for this? Please advise. Thanks in advance!
SQL Server Reporting Services
Sign in to answer