asked on

Access to sql database through VPN

I've set up Remote access VPN on sbs 2003 with ISA 2004 by following the MS TechNet walk-through.
From the client site I can connect, and browse files on the server, but cannot connect to a SQL database via a specific program I have (error code 3709).
I've opened ports TCP 1433 and UDP 1434 on the router (do I have to do the same in ISA?).
Any ideas would be very much appreciated.

nasirsh

You have to issue a command on the router of reverse-path and also should open ports on the ISA server. This would help

Rochford

ASKER

I created a custom protocol and added the 2 ports with 1433 outbound and 1434 send, but still no joy. I've attached screen shots of an ISA log at the tim ethe client logged on to the attempts to access the SQL DB.
Not sure what you mean by "issue a command on the router of reverse-path"
top-left.JPG
top-right.JPG
bottom-left.JPG
bottom-right.JPG

Rochford

ASKER

Sorry, wasn't clear with the first part of my last comment. I created the new protocol and added the 2 ports, then created the new rule with the following:
action - allow
protocols - the new one
from - vpn clients
to - internal

nasirsh

OK just tell me one thing. Are you using Router as a VPN Server or ISA

nasirsh

In th policy which you define for crypto there is a command of ip reverse-route which enables your local lan access to VPN client.

Rochford

ASKER

I haven't got DMZ mode enabled on the router as it says I need to change the NIC to DHCP

Rochford

ASKER

Anybody got any suggestions? Phoned 2 server support companies and was preperred to pay, but they were of no help. Wasted nearly a week on this now, but I need it sorted

ASKER CERTIFIED SOLUTION

Rochford

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial