Manual Headquarter Server Installation

1. Download: Microsoft SQL Server.

2. Installation Procedure:

   • Download Microsoft SQL Express Edition using the provided link.
   • Perform a custom installation and click on Install.

• Select "New SQL Server" and follow instructions until Next.

• In the "Feature Selection" section, select:

  

  • Database Engine Services
  • Data Quality Client
  • Client Tools Connectivity
  • Client Tools Backwards Compatibility
  • Client Tools SDK
  • SQL Client Connectivity SDK -> and click Next.

• Change the instance name to "IPos" and configure other options as needed.

• In server configuration, select custom "Collation" and set "Collation designator" to "Latin1_General" selecting "Accent-sensitive".

• Then, navigate to DataBase Engine Configuration ⭢ Mixed mode ⭢ Password : BBCTech12 ⭢ Add Current User ⭢ Next

• Complete the installation.

3. Download SQL Server Management Studio (SSMS) + Database backup and restoring:

   • Enter the credentials.

   • Go to RemoteDesktop 10.5.6.156 (the password can be found in the keepas), update the ipos from the desktop to the latest version, login with user:admin and the general password for the fashion clients. After this is done, make sure that the Database HQR version is the latest one, backup it, and put it on the RemoteDesktop where you are initialising the new client.

   • Right-click on Database ⭢ Restore Database ⭢ Select Device, then on the three dots next to it, add the file with the backup where it was saved.

   • In Security, right-click ⭢ New Login ⭢ Login name: IPos, choose SQL Server Authentication -> Password: BBCTech06, Uncheck "Enforce password policy".

   • Then, under Server Roles, select: sysadmin.

4. IPOS Installation:

   • Create the IPOS manifest using this documentation : https://github.com/BBCWiki/IPos-Internal/wiki/IPos-Deployment
   • Download from http://portal.sbsoftware.ro/ipos/Releases/.
   • After installation, connect to settings using the password: iposadm.
   • In Application, select the 3 strings and modify them with the new data from the created SQL.
   • Subsequently, generate a new license. The generated license is added to the -> License Code.

• Finally, log in directly with:

  • Username: admin
  • Password: 1111 or 9999

• into the Backoffice.

5. Configuration on SQL Server Configuration Manager:
   • Expand SQL Server Network Configuration → Protocols for IPOs → TCP/IP.
   • Search the enabled IP
   • Set TCP port to 1433. (also to the IPALL(down in the page))
   • Set IP Address to the IP of the RemoteDesktop
   • Restart SQL Server (IPOS) service.
   • Configure Windows Defender Firewall to allow traffic on port 1433. (WindowsDefenderFirewall -> Advanced settings -> Inbound Rules -> NewRule -> Check 'Port' oprion -> Set 1433 as 'Specifical local ports' -> set name to 'ipos' in the end)

Company and Store Configuration at Headquarters

Customer Configuration

Open IPos in BackOffice ⭢ Registry ⭢ Basic Information ⭢ Companies (Modify the name for each customer company)

Stores ⭢ Add ⭢ Store code or denomination plus the name ⭢ Select = Company

Execute SQL to enable the Licenses button in BackOffice

SQL Copy code insert into SecuritySystemPermissions (OID,Name, Description,CategoryId) values (NEWID(), 'sbLicenses', 'Registry ⭢ Base Informations ⭢ Licenses',3) This activates the Licenses button in BackOffice

Close and reopen Ipos

Backoffice ⭢ on 2. Store -> Modify the license then add the Connection String (obtained from another server = Data Source=localhost\IPOS;Initial Catalog=HQR ;Integrated Security=False; User ID=ipos ;Password=BBCTech06 ;Connect Timeout=10 ;Application Name=IPOS)

If the customer doesn't want, we add the instance the customer desires (SQLExpress)

Devices Printer ⭢ manufacturer ⭢ Epson Intelligent = save