?
Solved

Can't access SQL Report Server 2008 remotely (SSRS)

Posted on 2013-01-22
4
Medium Priority
?
3,604 Views
Last Modified: 2016-10-11
Hi,
I have SQL Server 2008 Reporting Services (SSRS) installed on a windows 2008 R2 server. I have configured the SSRS and it works perfectly locally on the server.
When I try to access the ReportServer (http://servername:8050/Reports) from a different PC on the same network , the request times out and get the "Internet Explorer cannot display the webpage" error.
The Service account that I ahve used for the SSRS is the "Network Service"

What could be wrong ?

Thanks
IE.gif
0
Comment
Question by:TetraSA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 total points
ID: 38813052
So that link works properly when you're on the local server, but not from another PC? My first inclination is that there's a firewall configured on the server - maybe the regular Windows firewall - and that the port you need (8050) is being blocked. From the local server, it doesn't go through the firewall, which is why it appears to work from the server itself.

Here are some instructions for adding firewall exceptions (it's for Windows 7, but the steps are the same on Server 2008 or R2):

http://www.sevenforums.com/tutorials/542-windows-firewall-add-remove-exception.html

Alternatively, you can try disabling the Windows firewall on the server and see if it works, just as a test - that's not ideal long-term, but it would avoid you going through the configuration process and struggling with whether you've done it correctly if things continue not to work. If you follow the steps, you should be okay.
0
 
LVL 11

Expert Comment

by:SThaya
ID: 38814204
0
 
LVL 1

Author Closing Comment

by:TetraSA
ID: 38873000
Hi,
Thanks ryanmccauley
That was exactly the issue. The windows firewall was blocking the port. I added the exception and now its working fine.

Thanks
0
 

Expert Comment

by:Karla Valencia
ID: 41838938
what except that you added?
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

762 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