Accessing SSRS from a Web server
Home > IT Answers > SQL Server > Accessing SSRS from a Web server
SQL Server Ask the Experts
2445 pts.
0
Q:
Accessing SSRS from a Web server
SQL Server Reporting Services, SSRS, SQL Server 2005, VPN, SSRS Access from a Web Server
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?
ASKED: Jul 9 2009  3:22 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Jul 9 2009  9:22 PM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0