Solved

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

Posted on 2013-01-22
4
3,367 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 500 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

732 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