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

 

[chakatheapeman]

Another approach that might work for you

If you get the deployment tool kit for access with visual studio, you could use terminal server to serve out clients. The runtime client that comes with the tool works pretty well. This way you could centralize you administration. My experience is that SQL over the internet is pretty slow. My users are data hogs they want to see everything before deciding what they don’t want to see.

 

[aaron.kempf]

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

make sure yotu have enough bandwidth