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.
| Author |
Topic |
|
pittrecon08
Starting Member
11 Posts |
 Posted - 2013-06-21 : 12:45:13
|
| 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 -->500System.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) |
|
|
|
|
|
|
|
What are required IP security rules for SSRS?