Sorry to bug you guys again but

[markjw]

This is a bit old, but it explains about the connection string and setting up different database configurations in detail:

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…

You also need Message Server running on the server machine and in client mode on other systems. If you don’t have Message Server running, changes of entities like tables changing colour won’t happen when done on other terminals. Here is guide on setting that up:

Message Server Tutorial

What is Message Server? Some users thinks they need to run Message Server to be able to connect to SQL Server. Message Server has no relation with database and if you have problems configuring database please read SambaPOS Database Configuration topic. After configuring database connection come back to this tutorial to complete your network connection. Message server is a special server application that enables communication between terminals. On a network environment waiters uses different t…

You need to ensure relative ports are allowed for both SQL Server and Message Server on Windows Firewall. You can read about it here:

[Solved] Multi-terminal / Message Server woes?

So to recap… ##Server On the Server, where SQL Express is installed, ensure these Services are running: SQL Server SQL Server Browser SQL Server VSS Writer (not required for remote connections, but needed for DB Backup/Restore etc.) [image] Create Inbound Rules in Windows Firewall to allow access to required Protocols/Ports: Control Panel > Windows Firewall > Advanced Settings > Inbound Rules > New Rule... TCP 1433 UDP 1434 TCP (choose a Port for Messaging Service) [image] [image] …

I know it is quite complex, especially if you haven’t done this before. I just realised the original message I linked to at the start of this topic explains installing SQL Server 2014 and also converting CE to SQL database, but doesn’t go as far as how to configure SambaPOS to connect. So I hope these few additional topics help you in that respect.