how to connect ms sql server from internet?

• aung sithu

  Grasshopper

  Points: 12

  More actions

  June 29, 2007 at 9:06 am

  #95227

  dear reader,

  i'm having problems with writing a distributed application.

  it's an sales tracking system and the branches are in different countries.

  they're currently using a windows application for each branch.

  i think it's possible to connect to a ms sql server which will be run at our server which is located at our ISP.

  but i don't know how to connect?

  please advise.

  thanks in advance.

  note: please advise if there is some other efficient way to get these data in real-time from all branches.

• bledu

  SSChampion

  Points: 12335

  More actions

  June 29, 2007 at 9:57 am

  #716244

  you can use replicated databases, i think they are better than trying to connect directly unless if you have super efficient connections

  ---

  Everything you can imagine is real.
  

• aung sithu

  Grasshopper

  Points: 12

  More actions

  June 29, 2007 at 10:05 am

  #716248

  thanks for your reply.

  one thing i'm getting confused is that i don't know how to make sql server connection using internet. because my previous programming experiences using sql server are only for LAN.

  and so database replication is not very familier with me as my projects are not as big as this time.

  please advise.