knowledge base

The multi-user functionality of inFlow is designed mainly for connecting computers over a local area network (LAN). We don't officially support using inFlow between computers connected over the Internet, but a number of people have done this successfully. Here are some tips that may help if you'd like to try this for yourself as well.

The three main ways of connecting inFlow over the Internet are: using remote desktop, using a virtual private network (VPN), and directly connecting over the internet.

Connecting using Remote Desktop

One way to allow access to inFlow from outside your LAN is to set up one machine on your LAN with inFlow and as a remote desktop host. Then, other machines can connect to this host via remote desktop, as if they were using that machine directly.

The remote desktop host will need to be running Windows XP Professional, Vista Business, or Vista Ultimate to host remote desktop. You may find the links below useful in setting up remote desktop. (Disclaimer: We don't have any affiliation with or endorse these links.)

Remote Desktop on XP:

http://www.online-tech-tips.com/windows-xp/how-to-setup-remote-desktop-on-windows-xp/

Remote Desktop on Vista:

http://www.mydigitallife.info/2007/01/26/turn-on-or-enable-remote-desktop-on-windows-vista/

Connecting using a VPN

You may also want to consider setting up a VPN to allow computers over the internet to access your LAN.

You may find the links below useful in setting up a VPN.(Disclaimer: We don't have any affiliation with or endorse these links.)

VPNs on XP:

http://www.onecomputerguy.com/networking/xp_vpn_server.htm

VPNs on Vista:

http://windowshelp.microsoft.com/Windows/en-US/help/f22a374f-929e-43bf-9583-de62942490e81033.mspx

Hamachi VPN software:

https://secure.logmein.com/products/hamachi/vpn.asp?lang=en

Directly connecting over the internet

If you're not able to set up remote desktop or a VPN, you may also want to have client computers connect directly to the database on the inFlow server over the Internet. Note that inFlow does not encrypt data sent over the network using this method.

To do this, when setting up inFlow to connect to the server for the Server Name, you'll need to put in the internet IP address of the server computer for the Server Name in inFlow. The easiest way to get this IP address is to use a web browser on the server computer, do an internet search for what is my ip address, and use the IP address given on one of those sites.

If the server computer is using a router, you may also need to set up port forwarding on the router to correctly direct connections to the server computer.

You may find the link below useful in setting up port forwarding on your router. (Disclaimer:We don't have any affiliation with this site or endorse it.)

Port forwarding for various routers:

http://portforward.com/

You'll need to do the port forwarding for SQL Server Browser on port 1434 for the UDP protocol.

Port forwarding for inFlow's SQL Server

To correctly set up port forwarding for inFlow's SQL Server, you'll want it to use the same port each time. To do this:

1. Run SQL Server Configuration Manager. On Windows XP, click Start, Run, and type sqlservermanager.msc. On Vista, click Start and type sqlservermanager.msc.
2. Open SQL Server 2005 Network Configuration, Protocols for INFLOWSQL, and right click on TCP/IP and select Properties.
3. In the properties dialog, go to the IP Addresses tab, and go to the IPAll section at the bottom. If the TCP Dynamic Ports field is set, clear it to be empty. Then, set TCP Port to an unused port number of your choice, e.g. 13724. Click OK.
4. Back in SQL Server 2005 Services, select SQL Server (INFLOWSQL), right click it and choose Restart.
5. Re-open the TCP/IP Properties window and check that the TCP Port is still set correctly to the port you chose. If not, pick another port number and try again.

You should then set up port forwarding for the TCP port number you chose above on your router.

Using an unchanging IP address

Most internet service providers (ISP) do not guarantee that you'll have the same IP address all the time; it may change each time you reconnect, or in less frequent intervals. This makes it less convenient for others to connect to you whether by VPN, Remote Desktop or direct internet connection to inFlow, since they will have to always use the most up-to-date IP address.

If you find this is a problem, you may wish to look into getting an unchanging IP address. This is typically called a static IP address, and some ISPs offer this as an extra service, typically for a small charge. Alternatively, you might look into a service which gives you a fixed address which you can keep updated to point to your server. This is often called Dynamic DNS. One site that currently provides this service for free, with some limitations, is linked below:

Dynamic DNS

http://www.dyndns.com/services/dns/dyndns/

You can then have client computers connecting directly over the internet use this as the Server Name instead of the IP address; or as an address when setting up remote desktop or a VPN.

Avoid bandwidth-intensive operations over the Internet

When connected over the Internet (or via a VPN over the Internet), using large pictures or file attachments may cause problems. We recommend using smaller pictures (100-200 kb) for your products and company logo, and to avoid working with large file attachments.

Also, the database backup and restore operations are very bandwidth intensive, and may be very slow or fail when initiated from a computer connected to the server over the internet. We recommend performing these operations from the server computer directly, or a computer connected to the server over a LAN.