Windows Forum

Ask something
Question Locked

Accessing a database remotely

0 helpful
3 replies

by budj

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to set up a remote access system at our stores so they can access our database remotely.
Microsoft Remote Desktop Access is not reliable or fast enough.
Is there a better method?
I was thinking of maybe Citrix with thin clients. That would also help restrict their web access and installation of applications. We've had alot of problems with computer viruses and malware and this would be a good way of controlling them.

3 replies

by captbilly1eye

You could set up a VPN, but when inputting data, the key things to keep in mind are speed, security and reliabilty. For that reason, your idea of thin clients using Citrix or a Terminal Server is a good one.

That way, users are actually accessing a local installation to view data or make changes rather than transmitting data remotely.

Good Luck.

by captbilly1eye

... many clients I work with use a citrix or terminal server solution. The company I currently work with provides software that accesses a SQL database where there is a designated database server and client installations on workstations. Their software is installed on the terminal or citrix server as a workstation and then the clients are responsible for setting up remote access to that installation. I have never been directly involved with the setup of such thin clients.
Therefore, you may want to create another Question in this forum so others with more experience in that respect can give you advice.

This discussion is closed to new replies.