November 29, 2012 at 6:04 am
Hello! I am trying to get my company to start using SSRS for reporting but I realized something today that I have never tried to use SSRS outside the local LAN before. Our application is external facing on the internet and if I implemented SSRS, I would need to be able to access the Report Manager via an external URL.
It is setup and configured currently, but I can only use it locally on the company domain. I tried searching the web for how to configure this and what best practice is but I didn't really get anywhere.
I imagine it would not be good to set it up on the same server that the database is hosted on? Has anyone done this before? I have setup one application that was inherently not meant to be external before to be external and it was a pain in the ***. 😀 Course, that application had to be proxied through Tomcat to IIS.
Anyhoo... any pointers or web references on how to do this? This would be done in SQL 2008.
Thanks!
November 29, 2012 at 10:50 am
I am assuming your company has a front facing web or application server that any external URLs would be hosted on? If so you could have your network admin set up a url that redirects to your Reporting Services URL. Because SSRS is active directory though, you are going to have to set up some sort of group for public securities so the people you want to access these sites would be plausible.
Link to my blog http://notyelf.com/
November 30, 2012 at 2:12 am
You could embed an iframe in your webpage, which fires off a request to the SSRS server using impersonation of a windows account which has access to the folders etc.
Look at annoymous authentication or forms based authentication
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply