Evopos Help - 2.09.090

Connecting to the database

Connecting to the database

Previous topic Next topic  

Connecting to the database

Previous topic Next topic JavaScript is required for the print function  

The first time you run Evopos it will bring up a 'Data Connection' screen where you can confirm the data connection details It will also bring it up if it cannot find the database or re registry entry is not found

Server name - The computer name or IP address of the computer where SQL Server is running.

Instance - New Default is: Evopos (Note: It was bbs on earlier versions). Note: If you are connecting over the internet you normally do not need to specify the Instance

Database Name - New Default is: EvoposMain (Note: It was BBSMain on earlier versions).

Database User - Default is: sa (Could also use BBSAdministrator1 is sa has been disabled for security reasons)

Database Pass-code - Default is: bbs1955

If you want to create a new SQL database on this computer, select New Database from the left menu. Evopos will first check for the existence of the Instance specified. If it does not exist Evopos will attempt to download and install SQL Server (Normally 2008 Express), create the Instance, create the database, and then restore a template backup (or one of your backups) to update the data.

Notes

If you need to view or change the default data connection details once Evopos is connected to a database you can select Settings / System / and see the current database to the right of the Change Database button.

You can also temporally switch to other databases while running Evopos by pressing Alt+F1 in any screen and setup different databases to connect to. Press Alt+F1 again when you want to revert to the default database.

We offer a free Installation service so please contact our Customer Services team if you would like us to install remotely or have problems installing.

 

Connecting over a Network (LAN)

Ensure the 'Firewall' on the computer running SQL Server has the SQL Exceptions set

To allow connections from other workstations over the network. The firewall could be Windows Firewall or a 3rd party Security / Anti-Virus package if that has been installed.

For Windows Firewall:

Select Start / Control Panel / Windows Firewall.

Select Exceptions or Allow a program or feature through Windows Firewall.

Select Allow another program and set the following two programs.

1: C:\Program Files\Microsoft SQL Server\90\Shared\SQLBrowser.exe.

2: C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Binn\Sqlservr.exe (Note - x is normally 1 however if other instances were setup first it may be a later number or have Evopos in it. Note: Look in the Data folder for the name of the database files to find the correct instance) .

Windows Firewall normally only blocks incoming connections. Some 3rd party security software solution also block outgoing connections so you may have to allow exceptions or disable on the computers trying to connect to the main computer.

Enter the correct connection details

If the data is on another computer, make we know the 'Computer name' (or IP Address) of the computer running SQL Server. We will set this as the Server Name on the Database connection screen. The other connection details should be the same as in the first section above.

Notes

If you are not sure of the connection details go to another computer that is connecting to the data, select Settings, ensure the top Tab is set to System and the bottom Tab is set to General, then see the text to the right of the 'Change Database' button (about 2/3s down the screen). For example if it says \\Server1\Evopos\EvoposMain then the SQL Server Name is: Server1, the SQL Instance is: Evopos and the SQL Database Name is: EvoposMain. The SQL User Name is normally: sa and the SQL Passcode is normally: bbs1955

 

Connecting over the Internet

Connecting over the Internet is useful for multiple stores or accessing remotely (without taking over a computer). It is also required for Evopos Mobile,  Evopos Cloud and some ECommerce integrations.

Ensure the settings for Connecting over a LAN are followed

See section above

Configure SQL Server for TCP/IP

Select Start / Programs / Microsoft SQL Server / Configuration tools / SQL Configuration manager.

SqlServerConfig2

On the left hand pane expand the SQL Server Network configuration option

Select Protocols for the instance (Normally BBS or Evopos), right click TCP/IP and select Properties.

From the Properties window select the IP Addresses tab. For IP1 (Or IPALL) and make the TCP Dynamic Ports blank (instead of 0), and set the TCP Port  (Normally 1433 or 34200) .

You will then have to stop and restart the SQL Server by selecting SQL Server Services from the left hand window, right click SQL Server Instance (Normally BBS or Evopos), select Stop, then select Start.

SQLConfig

 

Ensure you have a Public Static IP Address

You normally need to have a Static Public IP Address to enable users to connect to the data over the Internet. Contact your Internet Service Provider to see if you have a Static Public IP Address. You can check what your current Public IP address from Internet sites such as WhatsmyIPAddress.com. Note: Everyone on the internet has a Public IP address, but if it is not a 'Static' Public IP address then the IP Address could change every so often and you will not be able to connect until you update the Public IP Address. Note: There are also Dynamic IP services which is a small program that checks what the current Public IP address is and updates a web server so that the computer can be accessed by a unique URL Name.

Ensure that the computer running the SQL Server has it's Local IP Address set statically

This is so the Local IP address does not change when the computer or modem re-starts.

Go to the CMD prompt (select Run and enter CMD, or Windows key + R) and enter IPCONFIG. Make a note of the current Local IP address and the Gateway IP.

IPConfig

You can then ensure this will always be the same by selecting: Network / Properties / Network Adapter / Properties / Internet Protocol Version 4 (TCP/IPv4).

Then set 'Use the following IP Address' and set the Local IP address as above, the Subnet mask as 255.255.255.0, set the Gateway and Preferred DNS as the default gateway IP.

NetworkIPSet

Ensure your Router (Internet Modem) is configured to forward the port the SQL connection uses to the Local IP address of the SQL Server computer.

Configure your modem so that it knows what computer holds the database.

1.Find out your modems IP address (Normally: 192.168.0.1 or 10.1.1.1)

2.Log into your modem using the user name and password (Normally: user=admin pass=password)

3.Look for an option such as: 'Port Forwarding'

4.Add a rule that forwards your custom port (Step 1.8) to the local IP address of computer that is running SQL Server

5.Save modem settings

Notes:

For a guide on Port Forwarding see: http://portforward.com/english/routers/port_forwarding/routerindex.htm

The default SQL port is 1433, but for better security you may want to set it to something less common such as: 34200, if you do set it to a non default setting you will need to ensur the SQL Server is set up for this - See below).

Please see the instructions for your Router contact or contact your local IT specialist for more information.

 

Enter the correct connection details

On the Database connection screen, put the Public IP Address as the SQL Server Name . The instance is normally blank, but could be the same as above in certain confifurations. The other connection details should be the same as in the first section above.

Note: If you are connecting over the internet and using are not using Port 1433 you will need to enter: IP Address + "," (comma) + your custom port number Eg. 120.130.11.129,34200. Depending on the configuration you may need to leave the 'SQL Instance' blank.

Security - If you set up your database so it is accessible over the internet we recommend disabling the standard 'sa' user name and use a different (more secure) user name and pass-code Note: By default Evopos is normally configured with an additional user name of: bbsAdministrator1 and passcode: bbs1955