Solved

SSRS 2012 URL

Posted on 2016-09-04
11
65 Views
Last Modified: 2016-09-06
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
Comment
Question by:daise703
  • 6
  • 5
11 Comments
 
LVL 27

Expert Comment

by:Dan McFadden
ID: 41784582
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
 

Author Comment

by:daise703
ID: 41784632
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
 
LVL 27

Expert Comment

by:Dan McFadden
ID: 41784640
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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:daise703
ID: 41784778
If my Web service URL is reports and my report manager url is reportsmanager, why is my database called reportserver.
0
 
LVL 27

Expert Comment

by:Dan McFadden
ID: 41784796
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
 

Author Comment

by:daise703
ID: 41784832
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
 

Author Comment

by:daise703
ID: 41784837
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
 
LVL 27

Accepted Solution

by:
Dan McFadden earned 500 total points
ID: 41784859
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
 

Author Comment

by:daise703
ID: 41785004
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
 

Author Closing Comment

by:daise703
ID: 41785567
Thanks Dan for all of your help.
0
 
LVL 27

Expert Comment

by:Dan McFadden
ID: 41785817
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question