Configure Port Forwarding for Remote Workers (SQL)

Note: This guide is only for CurrentWare connecting to a SQL Database. Running Firebird Database with CurrentWare? Read this guide instead

Connecting the CurrentWare Clients (Remote workers)

To connect your CurrentWare Clients to the CurrentWare Server over the Internet, you will need to port forward the CurrentWare traffic from your network’s router to the CurrentWare Server computer.

#1 – Preparing your CurrentWare Server

First, you will need to set up your CurrentWare Server on a network that has a Public Static IP address (obtained from your Internet service provider).

Then, you will need to configure your router’s setting. On your router’s configuration page, go to the Port Forwarding Settings

Forward the following port traffic to the IP address of your CurrentWare Server computer.

  • 8990 to 8998 (TCP and UDP) – CurrentWare
  • 3050 (TCP and UDP) – Firebird
  • 1433 & 1434 (TCP and UDP) – SQL
  • 443 (TCP and UDP) – Web Services

This is a sample picture of a Linksys router’s port forwarding configuration screen. If you are not using Linksys, the menu items and labels may vary.

port-forward-linksys

This is how the port forward configuration will look like for a D-Link Router:

port-forward-dlink

Don’t know how to get into your router’s configuration page? Check out this resource:

http://portforward.com/english/routers/port_forwarding/routerindex.htm

#2 – Configure SQL Server Management Studio

  1. Launch the SQL Server Management Studio
  2. Log in to the SQL instance
  3. Right click on the instance that CurrentWare is stored and select properties
  4. Click on “Connections” and under the section “Remote server connections”, check the option “Allow remote connections to this server”
sql server management studio port forwarding

#3 – Configure SQL Server Configuration Manager

  1. Launch the SQL Server Configuration Manager
  2. Expand SQL Server Network Configuration
  3. Select Protocols
  4. Right click on the option “TCP/IP” and select “Properties”
  5. Click on the IP addresses tab
  6. Scroll down to “IPAll”
  7. For TCP Port, put in 1433
sql server configuration manager for Currentware

#4 – Installing the CurrentWare Client

Install the CurrentWare Client by running the cwClientSetup.exe file on the Client computer.

During the installation, put in the Public IP address, hostname or DDNS of the CurrentWare Server’s Network.

CurrentWare Client Configuration

Having issues connecting the external CurrentWare clients?

  1. Make sure the public IP address of your CurrentWare Server network has a static IP address
  2. Make sure your Firewall is not blocking the CurrentWare traffic

Connecting the CurrentWare Console

The Web Console of CurrentWare it has been made very simple to access your Administrative console from anywhere. All you need to know is the Public IP address (ex. 172.217. 22.14) where your CurrentWare server is installed on.

  1. Create your operators in the CurrentWare desktop application by going to Tools> Operators. You do not need to enable password security or stricter password policies for your operator account to work with the Web Console login page.
  2. Open the browser of your choice. The Web Console is fully function with all internet browsers.
  3. Enter your CurrentWare servers Public IP the browser URL bar with :8998 following it. An example would be 172.217. 22.14:8998.
  4. You will get the login page. You can enter your Operator Username and Password created in step #1.
Login

On the CurrentWare Console, go to Tools > Options > Connection > Type in the public IP address of the CurrentWare Server. Your console will now be connected remotely to your CurrentWare console off your network.

connect-cwconsole-to-cwserver-over-internet

Don't have CurentWare Installed? Download & Get started with a free trial!