Forum Home
Press F1
 
Thread ID: 68792 2006-05-11 00:22:00 remote access vpn/vnc etc drcspy (146) Press F1
Post ID Timestamp Content User
453978 2006-05-11 00:22:00 gotta request to try to setup a sysetm where four comps at different locations can access a database on a different comp . . . . . . . .

so: office has three comps, another comp elsewhere all needing to access a database at a third location . The database can be stored on a comp dedicated to this if necessary .

While I think this could be achieved with say 'radmin' or 'vnc' I'm wondering what'll happen in teh event, (as is very likely to happen) that more than one pc tries to access the database server at the same time .

I've looked into vpn a *little* but only have a very basic understanding of it . . . I'm gonna set up a 'trial' system but really need someone who knows how to do this to help with advice on programs etc . MOst likely the database comp will have a dynamic ip although this could possibly be changed to static at some tiem in the future .
drcspy (146)
453979 2006-05-11 00:48:00 Not sure if you are wanting to take control of database pc at same time or just have clients with application access to database.

If you want control or ability to input at same time, maybe RDP client with user sessions on windows 2003 maybe better suited.
SolMiester (139)
453980 2006-05-11 00:51:00 nope just need

ust have clients with application access to database.
drcspy (146)
453981 2006-05-11 01:09:00 The problem you will have with VPN only setup will be the amount of data that will get sent over the link (broadband? frame relay?) and will be very slow. A terminal server type setup would be better as the actual data is not being sent over the link, just screen, keyboard, mouse & print jobs if needed. CYaBro (73)
453982 2006-05-11 01:25:00 hm.............could you explain terminal server a bit more is that sorta like for example vnc whre you can 'take over' the pc similar to 'remote desktop' ? drcspy (146)
453983 2006-05-11 01:37:00 Yea it's basically the same as Remote Desktop in Windows XP but more than one user can log in at a time.
You need to run Windows Server 2000 or 2003 with Terminal Services in Application Mode to enable this.
Depending on what Operating System the clients are using, you may need to purchase Terminal Server Client Access Licenses as well as your normal client access licenses.
CYaBro (73)
453984 2006-05-14 06:31:00 Why don't you have a look at Hamachi? This is a really simple free VPN to set up. You might need to install it as a service on the machine you want to access. You can get a paid for version that is easy to set up as a service - setting up manually is is a pain. Grunter (10202)
453985 2006-05-14 06:34:00 I forgot to say that I access my work PC via a VPN using RDP. This setup, according to Steve Gibson, is very secure. There seems to be no speed penalty using RDP over this VPN (might be, but I can't notice it). Grunter (10202)
453986 2006-05-14 08:17:00 yeh I can remote access using a few different apps like vnc/radmin .....however the problem is I need to be able to have more than one user access at the same time without conflicting drcspy (146)
453987 2006-05-14 08:26:00 hm.............could you explain terminal server a bit more is that sorta like for example vnc whre you can 'take over' the pc similar to 'remote desktop' ?

A database can cover many sins. File locking comes to mind. In the event more than one person has access to the database and those people try to update the database then who gets in first ? Generally file locking is so that more than one person can't update or change a record at one time.

What Database are we referring to ? Access, DB, Oracle ?

What operating system is being used ?

Just to make things clear.
Sweep (90)
1 2