I'm Building a windows application which updates an internet site's database.
Is it possible to connect directly to the sql server through the internet?
If so is it the most efficient way ? perhaps a web service or streaming is a better solution?
Thanks.If you can VPN into the server, using normal SQL Server connectivity will be best. Web Services certainly could do it, though this might not qualify as "most efficient." You could connect directly through the internet if the correct port (1433 as I recall) is open. Leaving this port open is not a great idea, security wise. That is why a VPN would be a better solution, if possible.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment