SambaPOS

Documentation Website

User Tools

Site Tools


Sidebar

Installation

User interface

Basic concepts

  • Departments
  • Terminals
  • Users & user roles
  • Work periods
  • Tickets & orders
  • The POS menu
    • Products & product categories
    • Menus
    • Recipes
    • Product modifiers

Quick-start: setting up a (very basic) POS configuration

Advanced concepts

Customizing your POS system

Extra

Mobile Client

SambaPOS License

sql_server_setup

Considering where to install SQL Express

SQL Express database installs on computer that will work as the database server. All terminals will connect to this database server to read data and no SQL Express installation is required for terminals. Before starting installing SQL Express check network name for server computer and Using the PING Command to Test Network Connections to ensure all terminals can connect to server computer.

SQL Express 2014 Advanced 64bit Installation

It will run various checks to ensure it can install correctly. If it finds a service or windows feature not installed that it needs, it will recommend you install the windows feature before it will continue.

.net framework is the most common Windows Feature it may tell you to enable

New Installation / Add Features

Choose New Installation or Add features to existing install. For this example we are performing a new installation.

Accept the License terms

Installation options

The options chosen are all you need for SambaPOS. You can read about the other options if you are curious but they are not required.

Reporting Services is useful if you have more advanced knowledge of SQL; if not, you can de-select this and it will not affect SambaPOS functionality in any way. SQL Reporting Services has nothing to do with SambaPOS Reporting features.

Management Tools is not required but *highly* recommended so it is selected. Choose the instance directory: Default is fine.

You will notice it lists Prerequisites for selected installation features. These are typically just Windows

Features you can install through control panel / programs.

Instance Configuration

You can choose default instance (SQLEXPRESS) or rename it to whatever you want.

You'll need to know instance name while setting up SambaPOS database configuration so it might be a good idea to write it somewhere.

The `Instance` is not the same as the `Database`. Do not confuse the 2 terms. You can choose to have *many* `Databases` running under a *single* `Instance`.

Service Accounts

This tells it what to name the service that it runs as in the background and how it should start up. You should leave this default.

Authentication mode and User Accounts

For Database Engine Configuration you can leave everything default and allow Windows authentication mode it will run just fine.

If you plan to run multiple Terminals, it is recommended to enable Mixed-mode Authentication. In that case, you need to set a password for the administrative account. The initial admin account is named `sa` and you can set the password to whatever you like. We recommend `sambapos` as the password. You can optionally set up more admin users if you wish, but there is rarely a need to do so. You'll need this Password while setting up SambaPOS database connection.

This concludes the installation you now have SQL Express 2014 installed correctly and ready for SambaPOS to connect to it.

Testing the Installation

Lets open up Management Tools and test our installation. This program should be installed if you followed the above Tutorial steps. SQL Server Management Studio (or SSMS as it is often referred to as) is the tool we use to check if everything installed properly.

Available SQL Express Versions

  • 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
  • MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe
 Last 2 versions are not the actual SQL Express Database they are only the Management Studio Tool used to browse    
 and administer the Database. This tool is included in the ExpressADV and the ExpressAndTools versions.

Versions Recommended

  • ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe
  • ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe
  • ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe
  • ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe
sql_server_setup.txt · Last modified: 2019/04/19 03:20 by 93.179.68.108