how to connecto to a sql database stored in a computer that is in a lan

Question

HEllo,
I am kind of new in working with database, u usuallu work with control systems but this time I was required to develop an app that allows a user in any part of the world to connect to a database stored in a server that is in a home lan for instance. I guess that the first thing is to get a fixed ip address for my modem/router, is that correct? and secondly I have to configure my router to redirect data to the desired server, is that correct?
I would higly appreciate if anyone provides me with info for this app, or let me know where I can find info related to this topic

many thanks!
Fausto

Answer 1

Most home routers allow you to direct access of ports to one computer on the network!
example a web server will listen on port 80 so you tell the router to route port 80 to the web server.

Most ISP do not change your IP even if it is not fixed so you can look in the router what your outside IP and either give it to your customers or buy a domain name and give that to them

Do you know how to download SSDS?

---

Ofer

Answer 2

Ofer:

To answer your question - SSDS is a database service residing in Microsoft data center(s) and accessed via standard internet protocols (SOAP/REST).  So, no need to download anything. :) 

There are samples, documentation, etc. available on the SSDS Dev Center: http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx.

PatricMc