• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

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.
0
Rochford
Asked:
Rochford
  • 5
  • 3
1 Solution
 
nasirshCommented:
You have to issue a command on the router of reverse-path and also should open ports on the ISA server. This would help
0
 
RochfordAuthor Commented:
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
0
 
RochfordAuthor Commented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
nasirshCommented:
OK just tell me one thing. Are you using Router as a VPN Server or ISA
0
 
nasirshCommented:
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.
0
 
RochfordAuthor Commented:
I haven't got DMZ mode enabled on the router as it says I need to change the NIC to DHCP
0
 
RochfordAuthor Commented:
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
0
 
RochfordAuthor Commented:
Think this was a Kaspersky AV issue. sorted now
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

How do you know if your security is working?

Protecting your business doesn’t have to mean sifting through endless alerts and notifications. With WatchGuard Total Security Suite, you can feel confident that your business is secure, meaning you can get back to the things that have been sitting on your to-do list.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now