October 27, 2016 at 9:06 pm
Hi all,
I have a requirement. It is to expose reporting service on internet-facing web server by using report manager.
I want to allow my other users from other machine to access my reports on my report server when they just navigate my report server url. How can I make it happen? I do not wish to use AD because it is impossible to give bulk amount of user access with it. i was reading on Planning for Extranet or Internet Deployment https://technet.microsoft.com/en-us/library/ms159272(v=sql.105).aspx"> https://technet.microsoft.com/en-us/library/ms159272(v=sql.105).aspx I am having difficulty in starting up. Can I have some insight/ reference or tutorial samples on implementing this? Of course, Step by steps tutorial will be my best favourite. I am relatively new to SSRS and .I was completed SSRS form authentication from MSDN. From that I am not sure where to go next in order to achieve what I want.
Thanks for your time.
November 14, 2016 at 5:00 am
This all depends on how you want it set up, but is fairly easy.
I'm going with an assumption, right now, that you want your users to be able to navigate the portal, rather than having a specific report shown on a page (I have answered the latter in a different post, I will edit in a link later).
Setting up SSRS to be accessed from outside your local network isn't that difficult.
You'll firstly need to set up a domain for your SSRS Web Service. I assume you already have a web domain, so the easiest thing to do would be to create a sub domain on your existing domain (This is different for everyone's ISP, we cannot help you with how to set this up!). You'll then need to set that subdomain up so that it points to one of your external facing STATIC IP, where your SQL Server is hosted.
Next you'll need to update your firewall to ensure that requests to that IP are passed to your SQL Server. You only need to open port 80. DO NOT open any others.
Finally, update your Web Service URL in your Reporting Service Configuration Manager to the new subdomain address you created.
If you only have one Static External facing IP, and you are hosting a web service already, you won't be able to do the firewall and IP settings, as this will stop users being able to access your web server. Instead you will need to set up a Reverse Proxy on your Web Server. This is different on different Web Server Systems. Again, SQL Server Central is not that place to ask how to set up a Reverse Proxy, as it's not a SQL thing. It's unlikely that many of the user base here will be familiar on how to set this up for your own environment.
I would hope that as the DBA, you are not in charge of the Web Servers and Firewall in your company, so you will need to likely liaise with several members of your team to complete this. As I said, however, I (and other users here), can't give support on setting up your firewall, domain etc. You will need to consult your own documentation to do so.
Edit: Link to in-line reports answer.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 14, 2016 at 11:56 pm
Thanks for letting me know where to start for this case. Unfortunately, I have no access to Router setting and Network person was no where to be found in my current situation, unless I do all the things myself. I am not network person either. But it is totally no uses without having access to router. I have seen this one too. https://www.youtube.com/watch?v=VOUDdUJ5BLY"> https://www.youtube.com/watch?v=VOUDdUJ5BLY It is just a small portion of implementing this project.
November 15, 2016 at 1:54 am
Newbi (11/14/2016)
Thanks for letting me know where to start for this case. Unfortunately, I have no access to Router setting and Network person was no where to be found in my current situation, unless I do all the things myself. I am not network person either. But it is totally no uses without having access to router. I have seen this one too. https://www.youtube.com/watch?v=VOUDdUJ5BLY"> https://www.youtube.com/watch?v=VOUDdUJ5BLY It is just a small portion of implementing this project.
You will definitely need access to your firewall settings If he can't be found, my suggestion would be ping him and email and arrange a meeting. If you can't get that set up, you're not going to get anywhere.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 15, 2024 at 6:49 am
This was removed by the editor as SPAM
February 15, 2024 at 9:12 am
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply