Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 What are required IP security rules for SSRS?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

11 Posts

Posted - 06/21/2013 :  12:45:13  Show Profile  Reply with Quote
We installed SSRS 2008 R2 standard edition on web server(window 2008 R2 server). service account: built-in network service, current report server DB credential: SQL account, report server url :

On the web server machine, we opened TCP 8080 port and 1433-1434 port for both inbound and outbound. In the IP security list, we allowed SMTP, CSS, DNS server, TCP on 80,8080 and 1433-1434, and some specific domain accounts (including web server and DB server). Everything else is blocked. Then we cannot access report manager portal But We can still open If in the IP security list, we didnot block everything else. We can open the report manager url. What should we add in the IP security list? need open other ports?

The trace log error is :
ERROR: HTTP status code -->500
System.Net,WebException:Unable to connect to the remote server ----->System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection filed because connected host has failed to respond at System.Net.Sockets.Socket. DoConnect (Endpoint endPointSnapshot, SocketAddress socketAddress ) at System.Net.ServicePoint.ConnectSocketInternal (Boolean connectFailure, Socket s4, Socket s6, Sock&socket, IPAddress &address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception&exception)
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000