Thanks for your reply.
Here it is.
Briefly what i got for VPN:
Tunnel-group: SQL
Group-policy: SQL
User: hd_sql and cal (myself)
All the bold lines that I think of make VPN happenning except Split tunneling
Thanks in advance
: Saved
:
ASA Version 7.2(2)
!
hostname ciscoasa
domain-name cisco.com
enable password 8Ry2YjIyt7RRXU24 encrypted
names
name 192.168.0.3 DBS01 description SQL Server
!
interface Vlan1
nameif inside
security-level 100
ip address 192.168.0.154 255.255.255.0
!
interface Vlan2
nameif outside
security-level 0
pppoe client vpdn group pppoe
ip address pppoe setroute
!
interface Vlan3
no forward interface Vlan1
nameif dmz
security-level 50
no ip address
!
interface Ethernet0/0
switchport access vlan 2
!
interface Ethernet0/1
!
interface Ethernet0/2
!
interface Ethernet0/3
!
interface Ethernet0/4
!
interface Ethernet0/5
!
interface Ethernet0/6
!
interface Ethernet0/7
!
passwd 2KFQnbNIdI.2KYOU encrypted
ftp mode passive
clock timezone EST 10
clock summer-time EDT recurring last Sun Oct 2:00 last Sun Mar 3:00
dns server-group DefaultDNS
domain-name cisco.com
access-list inside_nat0_outbound extended permit ip host 172.17.a.b 146.178.c.d 255.255.255.0
access-list outside_cryptomap_20 extended permit ip host 172.17.a.b 146.178.c.d 255.255.255.0
access-list vpngroup_splitTunnelAcl standard permit any
access-list inside_nat0_outbound_1 extended permit ip any 192.168.0.192 255.255.255.224
access-list SQL_splitTunnelAcl standard permit any
pager lines 24
logging enable
logging asdm informational
mtu inside 1500
mtu outside 1500
mtu dmz 1500
ip local pool pool4vbs 192.168.0.201-192.168.0.210 mask 255.255.255.0
icmp unreachable rate-limit 1 burst-size 1
asdm image disk0:/asdm-522.bin
no asdm history enable
arp timeout 14400
global (outside) 1 interface
global (outside) 6 172.17.a.b
nat (inside) 0 access-list inside_nat0_outbound_1
nat (inside) 6 192.168.0.136 255.255.255.252
nat (inside) 1 0.0.0.0 0.0.0.0
route outside 0.0.0.0 0.0.0.0 61.9.y.z 1
timeout xlate 3:00:00
timeout conn 1:00:00 half-closed 0:10:00 udp 0:02:00 icmp 0:00:02
timeout sunrpc 0:10:00 h323 0:05:00 h225 1:00:00 mgcp 0:05:00 mgcp-pat 0:05:00
timeout sip 0:30:00 sip_media 0:02:00 sip-invite 0:03:00 sip-disconnect 0:02:00
timeout uauth 0:05:00 absolute
aaa-server RADIUS protocol radius
aaa-server TACACS+ protocol tacacs+
group-policy SQL internal
group-policy SQL attributes
dns-server value 192.168.0.1
vpn-tunnel-protocol IPSec
split-tunnel-policy tunnelspecified
split-tunnel-network-list value SQL_splitTunnelAcl
default-domain value cisco.com
username hd_sql password dXv9W2AE7LKH.KMX encrypted privilege 0
username hd_sql attributes
vpn-group-policy SQL
username cal password 6hgQbAkn8P0dkXKA encrypted privilege 15
username cal attributes
vpn-group-policy SQL
http server enable
http 192.168.0.0 255.255.255.0 inside
no snmp-server location
no snmp-server contact
snmp-server enable traps snmp authentication linkup linkdown coldstart
crypto ipsec transform-set TRANS_ESP_3DES_MD5 esp-des esp-md5-hmac
crypto ipsec transform-set TRANS_ESP_3DES_MD5 mode transport
crypto ipsec transform-set ESP-DES-SHA esp-des esp-sha-hmac
crypto ipsec transform-set ESP-3DES-SHA esp-3des esp-sha-hmac
crypto ipsec transform-set ESP-3DES-MD5 esp-3des esp-md5-hmac
crypto dynamic-map outside_dyn_map 20 set pfs
crypto dynamic-map outside_dyn_map 20 set transform-set ESP-3DES-SHA
crypto dynamic-map outside_dyn_map 40 set pfs
crypto dynamic-map outside_dyn_map 40 set transform-set ESP-3DES-MD5
crypto map outside_map 20 match address outside_cryptomap_20
crypto map outside_map 20 set peer 202.44.e.f
crypto map outside_map 20 set transform-set ESP-3DES-MD5
crypto map outside_map 65535 ipsec-isakmp dynamic outside_dyn_map
crypto map outside_map interface outside
crypto isakmp identity address
crypto isakmp enable inside
crypto isakmp enable outside
crypto isakmp policy 20
authentication pre-share
encryption 3des
hash md5
group 2
lifetime 86400
crypto isakmp policy 40
authentication pre-share
encryption 3des
hash sha
group 2
lifetime 86400
crypto isakmp nat-traversal 40
tunnel-group 202.44.e.f type ipsec-l2l
tunnel-group 202.44.e.f general-attributes
tunnel-group 202.44.e.f ipsec-attributes
pre-shared-key *
tunnel-group SQL type ipsec-ra
tunnel-group SQL general-attributes
address-pool pool4vbs
default-group-policy SQL
tunnel-group SQL ipsec-attributes
pre-shared-key *
telnet timeout 5
ssh timeout 5
console timeout 0
vpdn group pppoe request dialout pppoe
vpdn group pppoe localname vb39033@@isp.com
vpdn group pppoe ppp authentication chap
vpdn username vb39033@@isp.com password *********
!
class-map inspection_default
match default-inspection-traffic
!
!
policy-map type inspect dns preset_dns_map
parameters
message-length maximum 512
policy-map global_policy
class inspection_default
inspect dns preset_dns_map
inspect ftp
inspect h323 h225
inspect h323 ras
inspect rsh
inspect rtsp
inspect esmtp
inspect sqlnet
inspect skinny
inspect sunrpc
inspect xdmcp
inspect sip
inspect netbios
inspect tftp
!
service-policy global_policy global
prompt hostname context
Cryptochecksum:e01ee8d56b93078e8e649f444265ff7c
: end
asdm image disk0:/asdm-522.bin
no asdm history enable