Home

Products
       NCAA Tourney
       Loan Calculator
       Text / HTML Versioner
       HTML Fader
       HTML Scheduler
       SQL Reporting Services
       MySkype

Support & Forums
Tuesday, September 07, 2010 You Are Here: Support & Forums  | 
Welcome to Module Masters support forums - the primary support mechanism for our products. Feel free to post your questions, and we will aim to respond in a timely manner.  We also encourage our users to post any feedback you may have.  You may also email us directly at service@modulemasters.com
Forums > Module Masters Forum > SQL Reporting Services
Subject: Working on intranet, but not on internet
Prev Next
You are not authorized to post a reply.

Author Messages
stephen.frostUser is Offline

Posts:5
08/07/2007 02:30  

We've successfully deployed the module on our server and can access it fine from our local network (Intranet).  But when we try to access the reports when connected to the Internet we run into problems.  Our configuration:

* the website running DNN is publicly accessible (public IP address)

* the SQL Reporting Services server is NOT publicly accessible (only has private IP address)

What we observe in the client browser is the module displays for us a list of reports that we can run (so that much, at least, is working fine).

But when we actually select a report to be run, we see in the browser status bar that it is making calls to the private server name of the SQL Reporting Services machine ... of course, this fails, therefore we get an Error 404 eventually.
stephen.frostUser is Offline

Posts:5
08/07/2007 02:43  

I can see why now ... when I do a View Source on the rendered page when connected to my local network, I can see that the reporting services control is being delivered to the browser via an IFRAME, and clearly that won't work when connected to the Intranet and trying to access reports on a private server.

Is there any way around this?  We definitely cannot attach a public IP address to the reporting server.
hostUser is Offline

Posts:449
08/07/2007 08:03  
I am confused why it is not working. In theory, as long as the web server can see the SQL reporting services server, it should work. We have used it in this scenario before without issue. Do you have access to run the report from the web server itself to see what happens?
stephen.frostUser is Offline

Posts:5
08/07/2007 17:47  
I've just tried logging on to the WEB server (as administrator), opened a browser (IE), then browsed to the reports server (http://servername/reports). It was very slow the first time I clicked on it, perhaps after overnight backups if had to load a lot of stuff from disk ... but it did load the Reporting Services page okay. It also allowed me to browse through the folders of reports alright and run one of them.

So its only when the browser looking at the website is outside the network. Both the web server and the reporting services server are on the same physical and logical network.
stephen.frostUser is Offline

Posts:5
08/07/2007 19:18  
If you drop me an email (see details in my profile) I would be happy to arrange for you to have access to the web server in question, so that you can confirm what is happening.  It would be good for a separate set of eyes to look at the problem.
hostUser is Offline

Posts:449
08/07/2007 23:39  
We could possibly do a web session to look at the problem. Before we proceed with that, so we can get a better understanding, please screenshot the "server administration" page and the settings page of the module. You can email them directly to service@modulemasters.com or you can post them here.
stephen.frostUser is Offline

Posts:5
08/07/2007 23:46  
Screenshots on their way to you now via email. Thanks! Steve.
mrIT79User is Offline

Posts:1
09/15/2007 22:08  

I was wondering if there was any resolution to this?  I'm experiencing the same issue (RS 2000), and although I do have the option to put the report server on the Internet we purchased this module in order to continue hiding it behind the firewall.
hostUser is Offline

Posts:449
09/16/2007 16:05  
The issue as I recall was related to RS 2000 security. Unfortunately in 2000, there is no authentication interface to the reporting service that we can call to pass through the credentials, so what happens is the credentials specified in the server administration are used to pull back the report settings (e.g. the list of reports, folders, etc.), but when you go to run the report, it will prompt once per session for you to authenticate again, it can't pass through the credentials you have specified in the module settings. This issue does not exist in RS 2005 since they implemented an authentication interface. Hopefully this makes sense.
premkumarUser is Offline

Posts:3
05/08/2008 01:38  

High have the similar isssue that RS Reporting service works fine in Intranet but not seems to be on internet. Could you help me out of this
hostUser is Offline

Posts:449
05/08/2008 06:49  
premkumar, what version of SQL RS are you using?
premkumarUser is Offline

Posts:3
05/08/2008 08:14  

we were using SQL 2000(reporting service was working fine on internet) now migrated to SQL 2005 now reporting service works fine in intranet but not works on internet.   
hostUser is Offline

Posts:449
05/08/2008 21:19  
Can you explain how it is not working? Is it throwing an error? is it asking you to login? not really sure what you mean by it not working.
premkumarUser is Offline

Posts:3
05/19/2008 07:54  
When we try to connect reporting service from the internet it says "Page cannot be displayed" error.
hostUser is Offline

Posts:449
05/19/2008 08:28  
Please screenshot the server administration page and email it to service@modulemasters.com, sounds like a wrong URL is being used.
You are not authorized to post a reply.
Forums > Module Masters Forum > SQL Reporting Services > Working on intranet, but not on internet


ActiveForums 3.7
Copyright 2005 by Module Masters Privacy StatementTerms Of Use