title: how do I connect to database on server over ip
body: <p>We have  our  sql database on a server (remote)  . I have various clients  at different location  who have  windows application  (exe ) installed on their pc.How  do we  connect to the server .Should I go for change in connection string  contaning ip address or  ceate webservices for  accessing  database.Please provide  me  your  suggestion  as this  is   going to be  software related  to account.</p>