VB6 and SQL Server via RAS

[Bombdrop]

HI all
I'm going to be developing an app to allow or customers to access our internal SQL Server via a vb interface. NOw this is were I become stuck, how will they access the Server been looking round a bit and it seems that i must have a RAS ( remote acces serv ices) on the SQL Server and the client machines but that s all.

Now I'm sure the netwoirk guys at are place can handle the RAS but how would the the fact the Server is being access vai the internet affect my Connection string?

Thanks!!

[si_the_geek]

Thread moved and title changed to get a better response

[szlamany]

I used to RAS connect to one of my client machines.

That's a modem connection - so it's slow speed.

But once connected via modem to the RAS, the SQL BOX on that network appears local to the workstation.

So the connection string needs absolutely no changes.

You can test this all out by RAS connecting (we use a laptop to RAS connect) and using ENTERPRISE MANAGER to see if you can register the SERVER.

That customer has since evolved to using VPN for connection. Once I make a VPN connection (over the INTERNET!) - the SQL BOX server appears local to my laptop - very, very nice.

There is a link in my signature for adding "credentials" for remote boxes - if you happen to use WINDOWS AUTHENTICATION and run into issues...

[szlamany]

BTW - they did not put the RAS service on the SQL box - they felt safer putting it on a different server on that network - I think an old exchange box.