- Bronze, 100 points or more
it has been really long since i had posted any problem here, but this is really weird.
we have remote branches and remote POS connected over MPLS using GRE/IPSec Tunnel, recently we had upgraded one of our application servers which authenticate / connects branch office SQL server to head office SQL server and does some sort of publication and subscription.
after troubleshooting I discovered that GRE/IPSec Tunnel if removed from one branch (temp)the above mentioned scenario works perfectly otherwise, branch office SQL server cannot register the SQL server in headoffice using enterprise manager neither it can establish ODBC but it can surly see the databaes and there tables and make query.
can GRE/IPSec Tunnel make such a problem with SQL authentication, our GRE/IPSec tunnel config is as following
crypto isakmp policy 1
crypto isakmp key xxxx address 0.0.0.0 0.0.0.0
crypto ipsec transform-set strong esp-3des esp-md5-hmac
crypto ipsec profile securityvpn-profile
set security-association lifetime seconds 120
set transform-set strong
any guide line or help would be apperciative. thanks in advance