In this article
Store environment:
- Store Server that hosts: SQL database, Service Tier, and Data Director.
- POSs only run client, modern web client, and connect to the Store Server.
- POSs are reliant on the LAN in the store works and they have access to the Store Server at all times.
- Store backoffice users will connect to HQ via remote service or with modern Web client.
Data flow:
- HQ pushes master data to Stores and pulls transaction data from Stores to HQ.
- Web services are used for online requirements (inventory lookup, voucher validation and so on).
Store
SQL server
The Database Engine is the core service for storing, processing, and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise.
Data from Business Central (either from access into the system using Windows/web/mobile clients or through Data Director data replication) are read and written to the SQL Server database.
For more information see Microsoft SQL documentation.
SQL database
For LS Central, create a new database. Follow Microsoft's instructions for your version of MS SQL.
For more information see Microsoft SQL documentation.
Server account
The server account is used by LS Central to log into the Business Server instance and database. Creating a domain server account, instead of using the Network Service account, provides additional security as well as the ability to use the same account to run the SQL Server, regardless of whether the SQL Server is on the same computer or not.
The domain server account must:
- Be enabled to log in as a service.
- Be enabled to register an SPN on itself.
- Be added to the SMSvcHost.exe.config file.
- Be provided the appropriate database privileges in SQL Server.
Once the account is created, the next step is to assign the necessary SQL Server privileges.
For instructions on creating a Business Central server account and the SQL Server privileges to be assigned see Microsoft SQL documentation.
Business Central installation
Install Business Central with Custom Option, and install the following components:
- Client, with the following additional options:
- Business Central Development Environment
- Microsoft Office Excel Add-In
- Administration Tool
- Server, with the following additional options:
- Microsoft Office Outlook Integration
- SQL Server Database Components
- Microsoft Office Outlook Add-in
- Web Server Components
- Help Server
For more information see Installing Business Central using Setup.
LS Central Service Components
Install LS Central Service Components. The version will vary depending on the LS Central version.
Data Director for LS Central
Install Data Director services and configure hosts. Instructions are available in the LS Central Help.
Install OPOS Software
Optional. Only if Head Office has printers used for processes or testing.
POS
Hardware Station for LS Central
Hardware Station for LS Central is a Hardware Device Service for OPOS and other retail related devices. It is used to configure POS hardware devices. The devices that are currently supported by Hardware Station are:
- Authentication Device
- Dallas Key
- Cash Drawer
- EFT
- Line Display
- MSR
- Printer
- Scale
- Scanner
- Serial Device
For more information, see Hardware Station for LS Central in the LS Central Help.