Solved

SSRS 2012 URL

Posted on 2016-09-04
11
47 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

746 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

12 Experts available now in Live!

Get 1:1 Help Now