Correct procedure for adding a terminal to a database

[JTRTech]

Ok, not sure if already documented but searches obviously came up with allot of connection string related and activation topics.
As you may have seen in lounge topic been reworking the tills in new place and every single time I added a new terminal either new or after upgrading HDD to ssd etc (same thing samba wise) it knocked the database off activation…
Couldn’t work out the correct procedure;
Login market on samba first then change string.
Link to db then sign in etc…
Couldn’t get new machine to connect without then having to clear licence and reactivate… Or is that what needs to be done?

[Jesse]

Each till has to be activated.

[JTRTech]

Appreciate that but everytime I have to clear line ce on market.com and activate/signing I all,.

[Karim112]

Hi. I got samba on my first terminal with menu set up. How do I get samba terminal 2 with menu from terminal 1. Do I download samba pos on terminal 2.? How does menu transfer onto terminal 2? Any additional software download?

[Jesse]

To use multi terminal setup you need to install SQL Express 2016 and then connect each terminal to it via the connection string settings. Here are some tutorials to help you. These were written several years ago so the version of SQL might be dated but you can still follow them with SQL Express 2016 not much has changed.

SambaPOS Database Configuration

In this tutorial I want give some details about database configuration. tl;dr; See Step By Step SQL Server Express Setup document for multi user configuration. Introduction SambaPOS can work in three database modes. Demo mode, single user mode and multi user mode. Demo Mode You don’t need to install a database software just to evaluate SambaPOS. SambaPOS can work with a TXT file to let you understand basic SambaPOS functions. Some features might not work properly in demo mode so if you want…

SQL Express 2014 Installation - [BONUS] How to Convert from CE to SQL Express

Microsoft SQL Express 2014 [SQL Express 2014 Download Link][1] Versions Available Express 32BIT WoW64\SQLEXPR32_x86_ENU.exe Express 32BIT\SQLEXPR_x86_ENU.exe Express 64BIT\SQLEXPR_x64_ENU.exe ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe LocalDB 32BIT\SqlLocalDB.msi LocalDB 64BIT\SqlLocalDB.msi - MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe - …

Common Database Connection Issues - How to resolve them

This was written by @pauln I am just moving it here so it can help other people. Just in case you are still finding issues I will add the process I used as it highlights all the hotspots where roadblocks can occur. As a “freshman” I had to burn the midnight oil with this as well! Platforms Windows 8.1 - fully updated, Workgroups PC1 - Server ASUS I7 3ghz 16G Ram 27" Touch PC2 - Laptop ASUS I7 2ghc 4G Ram 15.4 Touch Check 1 - Services After install SQL Exp 14 as per tutorials …

[Karim112]

Once sql express 2016 install . I understand string part .How does both connect wirelessly or cable. Do I set both terminal on work network?

[Shivan]

Yes. Both terminals must be on same network for it to work

[Karim112]

On my first terminal I got menu setup . No menu setup Terminal 2 . Do I set up menu Terminal 2? What do suggest?

[Shivan]

If you already setup second terminal and second terminal is connected to first terminal database or server database then it will automatically show your terminal 1 or server menu.

[Karim112]

I just downloaded sambapos on my terminal 2 . Option of SQL express 2014 when downloading. Any other configuration needed?

[JTRTech]

You don’t need SQL on the seccond machine, you point second machine to first using connection string.
Go through the tutorials kendash posted, it’s all in there.

[Jesse]

The localdb SQL that is an option during install does not support multi terminal. You need to follow tutorials provided and install/configure SQL express