I have an application that connect to a local SQL server, but i need
to install the same application in another office outside of the
office. How can i make my application connect to my SQL server
remotely to make transactions?The app connects to your SQL Server using TCP/IP and some port number. If it is a default instance,
then the port is by default 1433. If it is a named instance, then you should look up what port
number the instance is using (pls post what version of SQL Server). So the app need to be able to
connect using this port, either by opening for the port in your firewall (NOT RECOMMENDED!!!) or
using VPN or similar.
Of course, you can re-architecture your app into either a n-tier app or by using HTTP endpoints
(assuming 2005), but I have a feeling that re-writing your app isn't an option.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Macana" <leninarias@.gmail.com> wrote in message
news:14ead399-dab5-4826-95c4-c280f8a485f3@.l32g2000hse.googlegroups.com...
>I have an application that connect to a local SQL server, but i need
> to install the same application in another office outside of the
> office. How can i make my application connect to my SQL server
> remotely to make transactions?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment