mobileRMS is driven by your database, this means your database needs to be accessible on the internet for mobileRMS to work.
mobileRMS has no offline mode, if it cannot access your database it simply will not work.To get mobileRMS setup you will need to have these things:
- Access to the computer with your RMS database
- Database name, username and password
- Internet with Static IP address or DynDNS
- Modem username and Password
- Average computer knowledge
If you don't think your up to the task you can always call your local RMS support engineer.
Step 1 - SQL Server Configuration
On this step we are making your database accessible on your local network.
- On the server computer open the start menu and navigate to the Microsoft SQL Server folder
- Within the Configuration Tools folder there will be an application "SQL Server Configuration Manager"
- Select SQL Server Network Configuration
- Select Protocols for MSSQLSERVER
- Make sure TCP/IP is enabled then right click on TCP/IP and choose Properties
- Select the IP Addresses tab
- Scroll down to IP ALL and clear any numbers in the TCP Dynamic Ports field
- In the TCP Port field enter a custom port number, we recommend 34200
- Click Ok, you will need to restart the service or your computer for changes to take effect
Step 2 - Computer Configuration
Now we are going to make your computers IP address static so that the modem can find your computer.
- Hold down the Windows Key + R
- Type cmd and press enter
- Type in ipconfig and press enter
- Take note of the IP address, subnet mask and default gateway (Eg. IP Address: 192.168.0.5 - Subnet Mask: 255.255.255.0 - Default Gateway: 192.168.0.1)
- Now right click on Network or My Network Places and select properties
- Select your Local area connection and select properties
- Click on the option "Internet Protocol Version 4 (TCP/IPv4) then select properties
- Choose the option "Use the following IP Address" and enter the details you took note in step 4
- Enter the default gateway IP into the Preferred DNS server
- Click Ok and then Close
- You will also need to make sure your computer firewall is allowing traffic to your SQL service
Step 3 - Modem Configuration
We will now configure your modem so that it knows what computer holds the database.Portforward.com Guide
- Find out your modems IP address (Normally: 192.168.0.1 or 10.1.1.1)
- Log into your modem using the user name and password (Normally: user=admin pass=password)
- Look for an option Port Forwarding
- Add a rule that forwards your custom port (Step 1.8) to your computers IP address
- If you have an option for a source IP address use 126.96.36.199, this will ensure you only allow access for mobileRMS
- Save modem settings
Step 4 - mobileRMS
- Log into your account and select the My Account option
- Fill in your connection details:
- SQL Server / IP Address = Your internet IP address + "," (comma) + your custom port number Eg. 188.8.131.52,34200
- Database = Your database name
- Username = SQL Username
- Password = SQL Password
- Select Save
- You will now have the option to select a cashier / user, select Save after choosing the cashier
We take securing your data very seriously, we encrypt your login details as well as your connection details.
Allowing access to your database over the internet
Lots of websites including eCommerce and Content Management Systems will use a Microsoft SQL database exactly like yours, the majority of these databases can be accessed from anywhere in the world, allowing your database to be accessible on the internet is common and safe.
There are a number for measures you can take for ensuring safe access to your database over the internet:
- Set a strong SQL password
- Custom ports - By using a custom port number you are making the address of your database unique.
Click here for more information on security
This page is print friendly.