Remote connection for SQL

Jul 27 04 10:41 am

How can I configure the wingate to connect to sql server remotly??

Jul 27 04 2:31 pm

If you want this connection to be established from the WinGate Server itself, it should simply be a case of doing it the way you'd normally do it from an Internet enabled computer. However, if this is giving you problems, check your firewall log. It is possible that some traffic might be blocked by the firewall.

If you want to establish the connection from a client computer, it might be slightly more involved. If this is the case, what methods do you use to connect the clients to the internet ? Are you going out through WGIC, proxies or are you using ENS/NAT ?

Jul 28 04 4:06 am

Ok, thank. Here is another question... How do I configure the wingate server to allow incoming connection to the sql server in my network?? Do I need to configure something in the sql server computer??

Jul 28 04 6:06 am

Easiest way is to set up a TCP Mapping Service.

I think SQL uses Port 1755 - don't trust my memory on that.

Set the service to accept connections on the External NIC and forward to the SQL server IP.

Remember - you're opening your SQL server to the bad folks on the Internet so be sure you have that latest security patches and strong passwords.

Larry