Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Skeezur
Starting Member
1 Post |
 Posted - 2005-02-16 : 23:57:04
|
| I am having a problem accessing RS reports from the Internet. Via the Internet, I can access the Report Manager just fine after being prompted with a Windows login box and logging in. Once authenticated, I can browse folders to the reports I want to run, but when I click on a report I get the "Page cannot be displayed" error. I captured a screenshot while the page was trying to load and on the status bar at the bottom of the window I can see it is referencing my internal server name when looking for the report .. the URL it is trying to open is http://myservername/reportserver?/nameofreport .. the difference being the URL I use for external purposes has the IP Address in place of "myservername". I am not sure how to get the URL to reference the IP Address instead of my internal server when clicking on the report to run it. Any help would be greatly appreciated. |
|
|
saglamtimur
Yak Posting Veteran
91 Posts |
Posted - 2005-02-22 : 04:24:03
|
| The Reporting Services setup program assumes that you will be accessing the Reports website using an address similar to http://MyRSServer/Reports. This works fine inside your network, but it probably isn’t going to work well if you want to make the Reports website available from outside your network. You will need to make a change to the configuration created during setup. To make this change, you will need to find the RSWebApplication.config file. The default location for this file is C:\Program Files\Microsoft SQL Server\MSSQL\ Reporting Services\Report Manager. Open the RSWebApplication.config file with a text editor. The first few lines of the file will be similar to the following:<Configuration> <UI> <ReportServerUrl>http://MyRSServer/ReportServer</ReportServerUrl> </UI>Replace the text between <ReportServerUrl> and </ReportServerUrl> with the complete address that should be used to access the Reports website, like;<Configuration> <UI> <ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl> </UI>or IP address<Configuration> <UI> <ReportServerUrl>http://212.155.88.10/ReportServer</ReportServerUrl> </UI>You will need to restart the IIS service for this change to take effect. |
 |
|
|
drace
Starting Member
3 Posts |
Posted - 2005-02-22 : 08:03:17
|
| saglamtimur,I was having a similar problem. I read your post and applied the change as you directed and I can now access report manager properly externally via internet. I want to thank you for the time you took in posting this explanation as it was the solution I was looking for...Don |
|
|
|
|
|
|
Reporting Services Internet Access Problem