Description
Outlines the steps involved in creating/recreating a blank SwiftPOS Back Office database.
To Be Considered
- If recreating a blank database for an existing SwiftPOS Back Office database, then make sure a backup has been made.
- The location of the existing Registration file will need to be known prior to commencing a recreate, as it will be required to re-register the recreated blank database.
- Note : If a SQL user other than the default sa user has been configured and is intended to be used to connect to the SwiftPOS database, then it is important to keep in mind that all the required permissions are set during a DB Upgrade. That includes the permissions for the SwiftPOS User role and Server State permissions (Encryption and SSL Connection).
Create a New Back Office Database
- Create a blank database. This can be initiated via:
- the SwiftPOS Back Office New Back Office Database menu item, OR
- SwiftPOS Back Office > Tools > Change Database menu option and then via the SwiftPOS - SQL Server Connections screen.
- For a first time created SwiftPOS Back Office database OR for an alternate database, SQL Server Connections will need to be created/changed.
- Login via the Clerk Login screen.
- Reset and Upgrade the newly created/recreated database.
- Start the SwiftPOS Services once logged into the newly created/recreated database.
- The newly created/recreated database should now be available and ready for use.
SwiftPOS - SQL Server Connection
To access this screen select Add / Edit SQL Database Connections from the SwiftPOS Back Office > Tools > Change Database menu option. The SwiftPOS - SQL Server Connections screen is used to create/maintain SQL Server Connection(s) to SwiftPOS Back Office databases. It also provides the ability to create a new database.
Grid
- Name - Displays the names of existing SQL Server Connections.
- Server - Displays the name of the server.
- Database - Displays the database name.
- Service - Select to run SwiftPOS Services. Select only if an instance of SwiftPOS services will be running on this PC. If making a connection to the server from a workstation that is not running the services then do NOT select this option. SwiftPOS Services only run on one machine on any one site or database and that is normally controlled by the File Server.
Footer
- Add - Select to open the Connect to Server screen and add an SQL Server Connection to establish a connection to the Back Office database.
- Remove - Select to delete the selected SQL Server Connection. Note the Current connection cannot be removed.
- Edit - Select to open the Connect to Server screen and edit an SQL Server Connection for the Back Office database.
- Tools - Select from the drop down list the following:
- Check for and Remove Orphaned Services - Select to view and uninstall any orphaned services. If no orphaned services are found, nothing is displayed.
- OK - Select to save any changes and exit. If the following pop up is displayed, then the Registration file will need to be re-imported. Select OK.
Select from the Back Office main screen select Registration (top right hand corner), to import the Registration file. |
- Close - Select to exit.
Note : You can add additional databases here if you have the knowledge on how to manage multiple databases on different port numbers that connect to SwiftPOS Touch terminals. For further information click here.
Connect to Server - Back Office
The content has been moved to the SwiftPOS Knowledge Base HERE
Connect to Server - Table Tracking
The content has been moved to the SwiftPOS Knowledge Base HERE
Running Multiple Instances of Back Office Simultaneusly
You can achieve this by using a /S:{Name} command line argument when running SwiftPOS.EXE You can do this easily by creating a shortcut to the SwiftPOS.EXE on the desktop and adding the /S:{Name} to the end of the command line.
The {Name} corresponds to the Name given when you setup your SQL Server Connections in SwiftPOS Back Office. Not the Database name:
(64 bit OS) "C:\Program Files (x86)\Samford Software\BackOffice\SwiftPOS.exe" /S:TRAINING
(32 bit OS) "C:\Program Files\Samford Software\BackOffice\SwiftPOS.exe" /S:TRAINING
Change Database Server
Description
If you are running a Bureau Service or Franchise Head Office with multiple Franchise Concepts across multiple Countries then you need to be able to run multiple instances of the services on the same PC. The other option is to use virtualised servers where each Franchise Concept is in a different workspace. If you want Voucher operation, you would need to run NetPOS.Net on separate Computers. There are long term plans to allow multiples of each interface in NetPOS.Net, however that is a huge development task
Note : If you are using multiple databases then you need to ensure that your SwiftPOS Touch terminals are all different numbers because they share the same update directory. This will be changed in 2013/2014. Leave gaps of 10 or 100 for Terminal ID?s per database.
Site 1 10 - Terminal ID 11 - Terminal ID 12 - Terminal ID Site 2 20 - Terminal ID 21 - Terminal ID 22 - Terminal ID etc.
Site 3 30 - Terminal ID 31 - Terminal ID 32 - Terminal ID etc.
Services check box option - This option determines if you are going to run an instance of the services on this PC. If you are making a connection to the server from a workstation that is not running the services then this option would not be selected. Services only run on one machine on any one site or database and that is normally controlled by the File Server.
Add - The first step is to add a new database here or use the option to create a blank database if you don't already have a database attached is SQL Server. It is important that you use the Username and password when you make a connection here so that the services can run.
Select the arrow in the top right hand corner to access the Database Connections panel. This enables one to quickly change the current database connection to one of the databases listed. Select a database and then log into that database with your normal Username and password. Note : Access to the Database Connections side panel can be hidden by using the /H command in the SwiftPOS Back Office command line. For example, "C:\Program Files (x86)\Samford Software\BackOffice\SwiftPOS.exe" /H or C:\Program Files (x86)\Samford Software\BackOffice\SwiftPOS.exe /H from Start
Before you start your SwiftPOS Services for each database that has been added
You will require a Software Registration for each database that you install. That is how the software is licenced.
Each Database needs to have a different folder for Sales processing. For example:
- C:\SwiftPOS\Site1
- C:\SwiftPOS\Site2
- C:\SwiftPOS\Site3
- C:\SwiftPOS\Site4
- etc....
Each Database will need the following :
- A different Port Number to connect to the database specific SwiftPOS Touch terminals.
- To have unique SwiftPOS Touch terminal ID's because they share the same update folder. This will change in 2013.
- To have a different Port Number for the Messaging Service if it is being used.
Open up Windows Task-Manager and you will be able to see the Service running for each database under the Processes tab.
Where are the Log-In settings stored?
C:\ProgramData\Samford Software\Settings.ini
C:\ProgramData\Samford Software\BackOfficeSQL.XML
If you have had failed connections for some reason, you may need to rename these files to make it appear like a new installation.
SQL Login Setup
Description
When you launch the SwiftPOS application you can drop down the SQL Server list and choose a Server and Database located on that Server. If you are accessing the SQL Server on a different port then enter the Server Name followed by a Comma and the port number. E.g.: SERVER-PC,5000 for a PC on Port 5000. If you are on the server you can leave the User Name blank for integrated security but not recommended because services need access to the SQL database when the user is not logged in. You are also able to create a blank database from this menu for new sites.
Clerk Login
Select the arrow on the right hand side to show/hide the available database connections. Select a database connection and login.
- Clerk ID - Enter a number 0-9. The default is 0.
- Pin - Enter the pin. The default is 0.
- Remember Me - Select to remember the login details entered.
- Connected SQL Users - Select to open the Current Client Access List screen:
- Shut Down - Select to close the current connection.
- OK - Select to process input.
Current Client Access List
To view the current list of Clients that are connected to the selected SwiftPOS Database.
- Host Name - Displays the server names.
- User Name - Displays the Usernames.
- Client Access Licences - Displays the total number of licences that the software is registered for.
- Current Client Accesses - Displays the number of licences currently used.
- Close - Select to exit.
Related Topics
- Installation
- Reseller Help - For Web Hosting information
- SQL Server Management Studio