Prev: The underlying connection was closed: Could not establish connecti
Next: Error: Subreport could not be shown. : A report with only one subreport
From: HollyylloH on 13 Jul 2005 03:32
I have a webserver with Windows Server 2003, IIS 6.0, and Report Server in a
DMZ. I have a second server with Windows Server 2003 and SQL Server 2000
behind a firewall. Before I opened the webserver to the Internet I was able
to connect the Report Server locally to a SQL database, now I am able to
connect to the Report Server (on the webserver), but when I click on the
reports I recieve a Page Cannot be Dispayed error. It appears the reports are
not connecting to the datasource. Anyone with an idea?

I am guessing at where the problem might be:

1) Do I need to change the datasource connection script?
data source=SQLSERVER;initial catalog=MyDatabase

2) Do I need to change the report server config files, but to what?

3) might there need to be a port opened on the firewall to the SQL
datasource or a reference to the webserver internet domain name or the SQL
server ( I don't know how to do this and would pass the info on)?

4) something else?
 | 
Pages: 1
Prev: The underlying connection was closed: Could not establish connecti
Next: Error: Subreport could not be shown. : A report with only one subreport