Con più domande
Reporting Services with Reverse Proxy

Domanda
-
Since IE 11 doesn’t support SSRS 2008 R2, we’re migrating to SSRS 2014.
Please, note that we can’t use IE 11 compatibility view.We access to the report server using https and reverse proxy. SSRS is in basic authentication.
Even if URL are correctly managed, most of our reports, use the “go to report” action.When we click on a button or link, SSRS is not able to resolve properly the request.
For example, our main page is:https://XXX.YYY.ZZZ/Reports/Pages/Report.aspx?ItemPath=/Reports/Main
The page contains some links using the “go to report” action.
When you go mouse over the link, IE shows the correct address in the lower bar, for example:
https://XXX.YYY.ZZZ/Reports/Pages/Report.aspx?ItemPath=/Reports/Main2%2fDettaglioFlussi&ExecId=wevyo0f5jrpglsyszuqpze45&PingId=w0hobi2ruhr3gc55ql0zsr45
but when you click on the link, you are sent to the wrong page:
http://XXX/Reports/Pages/Report.aspx?ItemPath=/Reports/Main2%2fDettaglioFlussi&ExecId=wevyo0f5jrpglsyszuqpze45&PingId=w0hobi2ruhr3gc55ql0zsr45
Using SSRS 2008 R2, we hadn’t any problem.
Thank you.
Tutte le risposte
-
Hi, see you the solution in the link below
Edoardo Benussi
Microsoft MVP - Directory Services
edo[at]mvps[dot]org- Proposto come risposta Edoardo BenussiMVP, Moderator mercoledì 7 ottobre 2015 06:42
- Proposta come risposta annullata Fabrizio-GMVP, Moderator giovedì 22 ottobre 2015 16:00
-
-
Can you explain what do you mean by "this solution doesn't work" ?
What happens ?
Edoardo Benussi
Microsoft MVP - Directory Services
edo[at]mvps[dot]org -
The workaround described in the suggested link:
wasn’t able to solve our issue.
I’ll try to give you more details about this problem.
Our infrastructure use this schema: EXTRANET <-> REVERSE PROXY <-> INTRANET
SSRS 2014 server is in the intranet part. Users consume reports from the Extranet, via reverse proxy. When you call a report using a URL, SSRS resolves correctly the address, both 2008 R2 and 2014.
When you call a report using the action “go to report”:
SSRS 2014 is not able to create the correct URL. Please note that SSRS 2008 R2 works correctly.
In the screenshot below, you can see Explorer Tool Developer, Network section for 2008 R2.
Reporting Services 2008 R2 makes a redirect using a relative path. See location row in blue:
The same report, published on 2014, works differently. Reporting Services 2014 makes a redirect using a static path:
The static path corresponds to the intranet address and the proxy server is not able to found the requested page.
It seem to us, that SSRS 2014 (and SSRS 2012, too) is not able to manage properly the redirect, while SSRS 2008 R2 was. Regards.
- Modificato MarianiP venerdì 9 ottobre 2015 11:23
-
ok, thanks..
see if the link below can help you
Setting up a Reverse Proxy using IIS, URL Rewrite and ARR
Edoardo Benussi
Microsoft MVP - Directory Services
edo[at]mvps[dot]org -
-
Do you know why SSRS 2014 has been changes respect to 2008?
i don't know..
but i'm reading these
https://msdn.microsoft.com/en-us/library/ms153586(v=sql.105).aspx
https://msdn.microsoft.com/en-us/library/ms153586%28v=sql.120%29.aspx?f=255&MSPPError=-2147217396
Edoardo Benussi
Microsoft MVP - Directory Services
edo[at]mvps[dot]org -
Hi Edoardo,
the suggested link:
is for IIS, but actually SSRS doesn't need IIS anymore:
Starting with SQL Server Reporting 2008 Reporting Services (SSRS) was the removal of the Internet Information Services (IIS) dependency, so you do not need to install IIS on the machine that you will install SSRS. This only applies when you configure it in native mode. In integrated mode you have to install SharePoint Web Front-End (WFE) components on the SSRS machine and this means a dependency on IIS, but that’s the dependency SharePoint has on IIS, not SSRS.
SSRS 2012 in native mode will use http.sys (think of it as a mini IIS), and cannot be configured to use IIS. But that should not matter as they can be installed and run side by side if needed. A lot of IIS-Like settings are configured by Reporting Service Configuration Manager.
We can temporary switch IE11 to compatibility mode, but it's a workaround. On the other hand, we can't change all "go to report" into "go to URL"...
-
-
Hi, this is the italian forum of SQL Server, for international forum follow this link:
-
Buongiorno Fabrizio,
forse ci sai aiutare. Abbiamo un problema con SSRS 2014. Come descritto nei post sopra, quando accediamo tramite reverse proxy al nostro server di reporting e agiamo su un'azione "vai al report", SSRS fa un redirect utilizzando un indirizzo statico invece del path relativo, come invece avveniva con SSRS 2008 R2.
Grazie e saluti
- Modificato MarianiP venerdì 16 ottobre 2015 14:52
-
if you try to consume reports directly from intranet, without pass through reverse proxy, with ie11, all works fine ?
Edoardo Benussi
Microsoft MVP - Directory Services
edo[at]mvps[dot]org -
-
potevi scrivere in italiano fin dall'inizio :)
adesso ci penso su visto che il problema è l'uso del reverse proxy...
Edoardo Benussi
Microsoft MVP - Directory Services
edo[at]mvps[dot]org -
Se può essere d'aiuto, con 2008 R2 funzionava senza problemi.
Secondo noi puo' essere legato a come viene costruito il reindirizzamento da SSRS.
Come soluzione temporanea, abbiamo impostato la compatibility view sui client IE11, in modo da continuare ad utilizzare 2008 R2.
Intanto grazie.
- Modificato MarianiP venerdì 16 ottobre 2015 15:13
-
Se può essere d'aiuto, con 2008 R2 funzionava senza problemi.
Secondo noi puo' essere legato a come viene costruito il reindirizzamento da SSRS.
Come soluzione temporanea, abbiamo impostato la compatibility view sui client IE11, in modo da continuare ad utilizzare 2008 R2.
Intanto grazie.
https://XXX.YYY.ZZZ/....
a
https://XXX/.....
giusto ?
Edoardo Benussi
Microsoft MVP - Directory Services
edo[at]mvps[dot]org -
-
se leggo qui:
For a report published to a report server configured for native mode, use a full or relative path without the file name extension. If the report is in the same folder as the current report, use the name of the report only. If the report is in a different folder on the same report server, use a relative path or a full path. A relative path starts from the current folder and moves up the folder hierarchy, for example, ../Folder2/Report1. A full path starts from /, the Home folder. For example, /Reports/Report1.
For a report published to a report server configured in SharePoint integrated mode, use a fully qualified URL including the file name extension (.rdl). For example, http://<SharePointservername>/<site>/Documents/Report1.rdl. Relative paths are not supported.
ref: https://msdn.microsoft.com/en-us/library/dd207116.aspx?f=255&MSPPError=-2147217396
io capisco che se il report server è configurato in "Sharepoint integrated mode" allora viene restituito il fully qualified url, che è esattamente ciò che manda in errore il reverse proxy quindi per ottenere un path relativo e non un path assoluto devo configurare il report server NON in "Sharepoint integrated mode".
Edoardo Benussi
Microsoft MVP - Directory Services
edo[at]mvps[dot]org -