Accessing SSRS from a Web server

Tags:
SQL Server 2005
SQL Server Reporting Services
SSRS
SSRS Access from a Web Server
VPN
We have a Web server at our collocation site with public access. On the server, there is a simple menu with links that call SQL Server Reporting Services. We also have another server -- with SQL Server 2005 -- that contains our database and reporting services. This one is only on the internal network -- there is no external access. How can we access SSRS from the Web server? As an example, I am using the following to call the report, which works when I have a VPN connection into the collocation. Then I have access to SSRS. http://192.168.8.214/ReportServer?/Reports/TMobileCommission&caller_co=<%=Session("caller_company_code_num")%> What can I do so that the front end application can go to this internal network where SSRS lives?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You’ll need to setup a web method on the public site which calls the private URL. We do this on our site to give our customers access to the reports server. I’m not sure the exact methods used, but the basics to Google will be that you are looking for code to create a proxy.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following