connection denied

donnie · ‎09-15-2008

Hi. I am using cisco asa5510 for my office network.My remote sql server which is outside my office network has problem replicating sql traffic to my sql server sitting in my office network. I have already allowed the public ip of my remote sql server to access my sql_server on port 1433. But why am i receiving the logs below which show that connection from sql_server to remote_sql is denied. I do not restrict my outgoing traffic from office network. Pls advise. Thks in advance.

2008-09-15 15:08:06 Local4.Info 192.168.x.x Sep 15 2008 00:09:18: %ASA-6-302013: Built inbound TCP connection 11594075 for outside:remote_sql/3725 (remote_sql/3725) to inside:sql_server/1433 (203.x.x.x/1433)

2008-09-15 15:11:34 Local4.Info 192.168.x.x Sep 15 2008 00:12:46: %ASA-6-302014: Teardown TCP connection 11593084 for outside:remote_sql/3650 to inside:sql_server/1433 duration 0:08:14 bytes 1116494 TCP Reset-O

2008-09-15 15:11:34 Local4.Info 192.168.x.x Sep 15 2008 00:12:46: %ASA-6-106015: Deny TCP (no connection) from sql_server/1433 to remote_sql/3650 flags ACK on interface inside

Collin Clark · ‎09-15-2008

Your remote sql server sends a TCP reset, but it looks like your internal sql doesn't get it or understand it and it tries to still communicate on the original TCP session.

Hope that helps.

donnie · ‎09-15-2008

Any advise on how i should solve the problem? My internal sql server has no replication from other remote sql servers. Only this particular sql server has replication issues. Thks in advance.