Solved

SSRS 2012 URL

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

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 26

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
 

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 26

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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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 26

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 26

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

937 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now