Accessing SSRS Web portal without hitting the direct server

Question

Dear All,

We have installed and configured SSRS on our database server. Which is having application databases and report databases. The access to the database is happening through application server which is running on dot net applications.

We want users to access SSRS webportal directly from their application without directly hitting the report database server. We want to restrict the users directly hitting the ssrs web portal as it is running on the database server. Kindly advice

Thanks

Abdul.

Answer 1

We want to restrict the users directly hitting the ssrs web portal as it is running on the database server.

Then create a web application, mapping/wrapping the SSRS report requests & results.

Answer 2

Hi @Anonymous

Do you mean want to integrate Reporting Services into the application?

You can refer to these links: https://learn.microsoft.com/en-us/sql/reporting-services/application-integration/integrating-reporting-services-into-applications?view=sql-server-2016,

https://www.mssqltips.com/sqlservertip/3021/how-to-launch-an-ssrs-report-in-a-browser-window-from-a-net-application/.

Hope these can help you.

Best regards,

Aniya