connecting to SQL Server over the internet

[bill]

My client would like to locate a SQL Server on an internet server, and have
clients connect with ADEs over the internet (with encryption).

Is this feasible in terms of performance? Has anyone tried this?

Thanks!
Bill

 

[J. Clay]

I have done it through a VPN connection. It worked, but the key was to be
extremely limiting in the data returned to the client. All of my primary
forms are based off of Stored Procedures that return only one (1) record,
thus the data going over the wire was relatively small.

I personally am not a fan of having a database open in anyway to the
internet other than via VPN as the security needs scare me. (Just my
paranoia shining through )

HTH,
Jim

 

[Vadim Rapp]

Hello,
You wrote on Thu, 8 Sep 2005 16:13:49 -0400:

b> My client would like to locate a SQL Server on an internet server, and
b> have clients connect with ADEs over the internet (with encryption).

b> Is this feasible in terms of performance? Has anyone tried this?

Yes, it works OK. But of course ou have to careuly plan your security.

Vadim Rapp

 

[aaron.kempf]

yes, I have done this previously also. it worked much better than
expected.

make sure yotu have enough bandwidth