09-15-2008 12:30 AM
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
09-15-2008 05:11 AM
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.
09-15-2008 07:42 AM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide