SQL Server connection - WeOnlyDo Discussion board

SQL Server connection (wodVPN)

by Mihail, Tuesday, January 29, 2008, 16:08 (6141 days ago)

I saw this on your wodVPN page:

wodVPN can be used to connect through VPN do your SQL server (which is mapped through local port)

I downloaded and installed the demo and went through the samples, but I'm affraid I don't understand what is needed to solve my problem.

What I'd like to do is:

- have a single MS SQL Server installation on one machine, behind NAT
- have users of my client application connect through VPN over internet to this server

What are the steps that need to be done on the server side and on the client side?

Thank you very much.

Re: SQL Server connection

by wodSupport, Tuesday, January 29, 2008, 16:15 (6141 days ago) @ Mihail

Mihail,

you should add new channel (TCPLocalListen) that listens on local port 1433 (this is MS SQL server port, right?) and redirects it to remote peer's 1433. After that you would point your MS SQL to 127.0.0.1:1433 and wodVPN would route it to remote peer's 1433.

http://www.weonlydo.com/VPN/Help/WODVPNLib~VPNChannels~Add.html

Is this what you had in mind?

Kreso