Connecting MSSQL SERVER 2000 Remotely with PB9

[radieux_scablem]

---

Hello,

Can I connect my office database server through Internet from a remote
location?

My Environment
Power Builder Application
SQL Server 2000 (at office server)
No Static IP Address

It should be possible to connect to my office server from any place
using internet connection. Though some security constraints are there
I need to know whether it's possible?

Cheers!!!
Radieux_scablem

[eax]

I think possible na siya if the Server has a public ip.

I think security risk na siya if ang MSSQL server gi-public ang ip.

[cold_fusion]

It's possible.
If your IP is dynamic, you could use dynamic DNS.
For security, you could route your traffic through VPN.
Unsecured and open MSSQL ports leads to vulnerability or brute force dictionary crack.