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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Report Manager access from another computer

Author  Topic 

harlingtonthewizard
Constraint Violating Yak Guru

352 Posts

Posted - 2010-03-12 : 02:58:26
I have been using sql server 2005 reporting services Express and could enter http://localhost/Reports$XTRALIS_CYCLOPS on the local computer or http://172.20.253.135/Reports$XTRALIS_CYCLOPS on a remote computer to see report manager. Now I have changed to sql server 2008 reporting services Express I can enter http://localhost:8080/Reports_XTRALIS_CYCLOPS on the local computer to see report manager however if I enter http://172.20.253.135:8080/Reports_XTRALIS_CYCLOPS on a remote computer I get a web page that indicates Network accessmessage: the page cannot be displayed. My sql PC is Win XP SP 3 and the remote PC's are XP and Win 7. The PC's are on a domain. I do need this to work from any OS above XP. I have tried changing the port to 80, 81, 99 in Reporting Services Configuration Manager in the Web Service URL but then I get error 400 and 401 even on the local PC.
Also If I change http://172.20.253.245:8080/Reports_XTRALIS_CYCLOPS/Pages/Folder.aspx to http://butterfingers:8080/Reports_XTRALIS_CYCLOPS/Pages/Folder.aspx it works from a remote computer? This concerns me;

http://msdn.microsoft.com/en-us/library/bb630447.aspx

****from above web page.***

Specify the port. Port 80 is the default for Reporting Services on Windows Server 2003, Windows Vista, and Windows Server 2008 because it can be shared with other applications. If you are using 32-bit Windows XP SP2, the default port is 8080. If you want to use a custom port number, remember that you will have to always specify it in the URL used to access the report server. You can use the following techniques to find an available port:

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-12 : 18:06:33
I believe XP and Win7 have firewalls which prevent remote access to them. See if disabling them fixes the issue or add a rule to them to allow the access.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

harlingtonthewizard
Constraint Violating Yak Guru

352 Posts

Posted - 2010-03-14 : 21:01:16
It turns out the problem has nothing to do with a remote computer. The problem also occurs on the local computer as well? If I use IP address report manager is not displayed, while if I use computer name it is?
Go to Top of Page
   

- Advertisement -