Roxanne25
asked on
SQL 2008 - Setting Up SSRS Externally
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 ass. :D 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!
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 ass. :D 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!
ASKER
No, people who use our application will not be on VPN. Our application is external on the internet.
I think the answer to your question is yes... I just want the report server available both locally and externally. So users can view SSRS reports from our website.
I think the answer to your question is yes... I just want the report server available both locally and externally. So users can view SSRS reports from our website.
You can publish reports to externally accessed site.
You should make sure to secure access including user logins.
http://msdn.microsoft.com/en-us/library/ms159106(v=sql.105).aspx
The VPN question related to my impression that the SSRS being external to your network where your sql server is.
Look for ssrs report publishing. Are you using share poin? What eternal setup do you have I.e. a web server that can be setup to serve up published reports?
You should make sure to secure access including user logins.
http://msdn.microsoft.com/en-us/library/ms159106(v=sql.105).aspx
The VPN question related to my impression that the SSRS being external to your network where your sql server is.
Look for ssrs report publishing. Are you using share poin? What eternal setup do you have I.e. a web server that can be setup to serve up published reports?
ASKER
No, we don't have sharepoint. Our application is a home grown system built in Cold Fusion.
No, SSRS is setup and installed on the same server as our SQL Server DB. This is a separate server from our application web server.
No, SSRS is setup and installed on the same server as our SQL Server DB. This is a separate server from our application web server.
You can create interface to give access of SSRS report to no-Doamin users.
ASKER
How?
ASKER
Ok, so I guess the answer to my question is that it can't be done? What I had wanted to do was make http://localhost:8080/reports an actual internet site that people could navigate to outside the local LAN. I was hoping I could do this and just be able to use the built in Report Manager and not have to write code to just gain access to a specific report. And it would have to use SSL.
You could port forward requests to port 8080.
Make sure to remove anonymous access from the virtual reports directory properties.
Make sure to remove anonymous access from the virtual reports directory properties.
ASKER
So, if they set up an external URL with an IP address then they could forward that to the internal reporting server address? Sorry I'm a database developer not really a networking person and I don't really have anybody else to bounce this off of.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks arnold! That gives me a lot to go on and I am more clear now on what needs to happen. Guess we'll just have to figure out what the best solution would be.
Yea, I have used SSRS pretty extensively and I love it and at other places I've worked have set up many subscriptions and different delivery methods. But usually, the company I work for is all internal and the only people looking at the reports are inside the domain.
So, I've never had to set it up where everything is external facing and most users are all remote and not accessing our application through a VPN.
So, where I am now they have never used SSRS and I'm trying to get them to see the light and convert this horrible hyperion report into SQL. I just have to make sure its available via our website.
I guess most people that use SSRS don't use the report manager for a user interface eh? Guess I'm the odd ball. :D
Thanks for the help!
Yea, I have used SSRS pretty extensively and I love it and at other places I've worked have set up many subscriptions and different delivery methods. But usually, the company I work for is all internal and the only people looking at the reports are inside the domain.
So, I've never had to set it up where everything is external facing and most users are all remote and not accessing our application through a VPN.
So, where I am now they have never used SSRS and I'm trying to get them to see the light and convert this horrible hyperion report into SQL. I just have to make sure its available via our website.
I guess most people that use SSRS don't use the report manager for a user interface eh? Guess I'm the odd ball. :D
Thanks for the help!
Are you looking to provide users who authenticate access to view reports while using internal references to create them?