Microsoft SQL Server Desktop Engine - How to access an MSDE database over the internet?

Author

How to access an MSDE database over the internet?

Charles C.

2005-11-08, 4:10 pm

How would I access an MSDE database on a win2k server over the internet?

helmut woess

2005-11-08, 4:10 pm

Am Sat, 5 Nov 2005 13:12:06 -0500 schrieb Charles C.:

> How would I access an MSDE database on a win2k server over the internet?

a) The server must have an official address for the internet, no internal
IP like 192.168.x.x
b) the server must be reachable from outside, not blocked by a firewall
c) that's all, use the ip like you do in the internal network

The only part: so you are totally unsecured, everybody can connect (or try
to hack your sa password), the traffic runs unencrypted over the internet,
even the login is unencrypted! Easy to find for a profi hacker.
Use SSH or VPN to encrypt the traffic or configure the firewall from the
server that only defined IP addresses can connect (which does not encrypt
the data you are sending).

bye,
Helmut

Sponsored Links