Solved

SSRS 2012 URL

Posted on 2016-09-04
11
62 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

832 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