[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 101
  • Last Modified:

SSRS 2012 URL

I am having issues getting a SSRS report site up and running and making it accessible form the internet. I can access the Report Manager URL from inside my network. I can also access the Web Service URL but is shows in all text. I can't access any of them externally. I have a SSL certificate and I have redirect setup with our hosting company. When I try to access the site externally, the page is forwarded to our main site.
0
daise703
Asked:
daise703
  • 6
  • 5
1 Solution
 
Dan McFaddenSystems EngineerCommented:
Here's a link on how to configure the SSRS website URL:

- https://msdn.microsoft.com/en-us/library/ms159261(v=sql.110).aspx

Here's a link on setting up access to the various URLs in SSRS:

- https://msdn.microsoft.com/en-us/library/ms153586(v=sql.110).aspx

As for the Web Service, of course it returns only text, the web service returns only data not formatted mark up.

Now for a few questions for you:

1. You have an SSL Certificate for what?
2. What exactly does the your redirect with your hosting company do?  What is redirected to what?

Dan
0
 
daise703Author Commented:
Dan

I have an SSL certificate from GoDaddy for *.mycompany.com. I am redirecting reports.mycompany.com to 111.999.50.113/reports. I am wondering if it should be reports.mycompany.com?
0
 
Dan McFaddenSystems EngineerCommented:
So, are you allowing http/https traffic thru your firewall to the SSRS server?  In general, I would think the redirect is efficient.

Dan
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
daise703Author Commented:
If my Web service URL is reports and my report manager url is reportsmanager, why is my database called reportserver.
0
 
Dan McFaddenSystems EngineerCommented:
There is no realtionship between the web service URL, the report manager URL and the SSRS database.  
The SSRS database is by default called ReportServer, changing it would be complicated.

A URL is just that, a pointer to a web application that fetches data from somewhere.  In this case, from SSRS.

So, I ask again, are you allowing http/https traffic from anonymous locations, thru your firewall to your SSRS Server?  You need to speak with your network/firewall admin to make sure network traffic can get to your server.

Dan
0
 
daise703Author Commented:
I am allowing https traffic over port 443 through my firewall. I am new to SSRS and I have trying to trouble shoot this problem. When everything worked, a user could go to reports.mycompany.com and that would get redirected to my SSRS SQL Server. Isn't the web service url suppose to redirect to the report manager url? When I click on the web service url I get the text version of the report manager url.
0
 
daise703Author Commented:
When the web service url comes up I get all text, when I lick on a link, it then takes me too the report manager and it's not text. When click the web service url, shouldn't it redirect me to the report manager url?
0
 
Dan McFaddenSystems EngineerCommented:
Why not take a step back and try getting it up and running on just http (80/tcp)?

Also, all of the SSRS URLs must be configured for https, if not you might experience issues.  Have you gone thru of all this:  

- https://technet.microsoft.com/en-us/library/ms345223(v=sql.110).aspx ?
- https://technet.microsoft.com/en-us/library/ms159261(v=sql.110).aspx

Can you post screen shots?

Dan
0
 
daise703Author Commented:
Do you know how to add an image to the report? It would be really cool if I could add our company logo to the reports.
0
 
daise703Author Commented:
Thanks Dan for all of your help.
0
 
Dan McFaddenSystems EngineerCommented:
Sorry for the delay, unfortunately I do not know much about customizing reports build with/in SSRS.

Glad to be of help.

Dan
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now