Question Locked

Access sql server outside office

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a static IP, beetel 440TXI ADSL2 Series router and Windows 2003 server machine. My internet line is connected to Router (DHCP enabled) which has one static IP. Now i want to assign an Statis IP for 2003 Server machine so that i can access my database/server from any where in the world? Please suggest me with clear details.

Thanks in advance.

5 replies

by scott_heath

Since very router has different config options, one can't be too clear. Most router do have a "DMZ" option that allows you to have the router forward pretty much all traffic to that one internal IP that hits the external IP. I do not recommend this. Instead, use port forwarding where you specify ports (like 1433 for a standard SQL Server build) to forward to 1433 on a specific internal IP.

Please consult your router manual for more specific instructions.

Regards,
Scott

http://scottisageek.spaces.live.com

by cmiller5400

I don't know if the 440TXI ADSL2 router can do this, but you would need to set up port forwarding on the router and give the Windows 2003 server a static private IP on your LAN.

by robo_dev

will have access to your server.

You need a hardware firewall and a remote access solution using VPN technology.

If you expose your database to the web, one third of the fourteen million hackers will fall off their chair laughing, another one third will think it's a honey-pot (trap) and stay away, and the other one third will hack in just for fun.

by mmcm888

As stated earlier, forwarding a port to your SQL server will attract hackers. An alternative is to use a hosted VPN service (such as AccessMyLan) which does not require an open inbound port. These types of service provide a full VPN so each remote user of the database will authenticate with the service before they can connect. You will not need to change any IP addresses as the server establishes an outbound connection to the hosted VPN.

mo.

This discussion is closed to new replies.