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

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

pittrecon08
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 : http://123.234.45.345:8080/reportserver.

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 http://123.234.45.345:8080/reports. But We can still open http://123.234.45.345:80. 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 123.234.45.345:8080 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  
 New 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.06 seconds. Powered By: Snitz Forums 2000