Remote users

RobySpain

Hello,

I would know which is the best way to connect remote users (from differents countries) to the same database.

I am thinking in Terminal Server, but I would like to know your opinion.
Are there more options? is it possible connect directly someone by TCP/IP thougth the internet?

I would have 2 remote users in China (permanents), 3 remote users in Mexico, and the main database in Spain.

Is better this option or different database and sincronize all of them?

Thanks for your comments.

Roberto

Savatage

here's a small discussion on the topic - you can search this forum too just as the post suggests to search mbsonline.org

http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=14679

note: msbonline has been running a bit slow lately - so give it a sec it will pop up...eventually. JK

Denis_Petrov

Terminal Server is your only solution. We have about 80 offices accross 4 time zones and a foreign country accessing our server in one location. To sync dbs is to lose sleep - it will be very hard to accomplish and simply not worth it. And it is fast too - I tried it even on a very slow dial up connections.

dmitrip

We used separate SQL server and Navision per location (which is a separate legal entity with all operations) plus SQL transactional replication with the central office.
The reasons are:
1. Speed. They couldn’t wait even 1 sec. (we tested Terminal Server and delay was about 1-2- sec.).
2. Reliability. We didn’t want to be dependent on the channel.