Lock-S - Synchronizing Databases with a second computer

Lock-S - Synchronizing Databases with a second computer

Premise

This guide will provide the basic instructions on how to set up a secondary computer and have it access the same Lock-S database as the main computer.


Note: While initial installations are included in the original price, subsequent installations by KAS (e.g. secondary computer or re-installation in case of computer failure) will incur a charge as per our IT Services policy.
This is on applicable to subsequent installations done by KAS.

Prerequisites

  1. Main computer fully configured and installed as per the instructions in this article.
  2. Admin privileges and passwords on both computers
  3. Lock-S installed on the secondary computer (no need for the rest of the components, such as the SQL Server Management)

Main Computer Steps


Locate SQL Server Configuration Manager

  1. Press Start
  2. Type in "SQL server configuration manager"
  3. Launch and proceed to the next step
If it does not appear under your apps, instead go to:
"C:\Windows\SysWOW64\" and locate "SQLServerManager11" in the files there.

Configuring with the SQL Server Configuration Manager

  1. Locate "SQL Server Network Configuration" on the left-hand window (Fig. 1)
  2. Select "Protocols for KASDB" (Note: KASDB might be named differently, according to your initial set up)
  3. Double-Click "TCP/IP"
  4. Change "Enabled" to "Yes"
  5. Select the "IP Addresses" tap
  6. Scroll all the way down to  "IPAII"
  7. Select "TCP Dynamic Ports" and type in the port you wish to use (e.g. 15133)
  8. Press Apply and OK
Note: Avoid using reserved ports, such as 433 and 80. If in doubt, use a 4-digit random number.

Configuring the Firewall

  1. Press Start
  2. Type in "Defender Firewall" and open the app
  3. Select "Advanced Settings"
  4. Right Click "Inbound Rules" and "New Rule"
  5. In the "Rule Type" window select "Port" and click Next
  6. Ensure that "TCP" is checked, and type in your selected port in the bottom bar (e.g. 15133)

Ensure the database is on the local computer

  1. Press Start
  2. Type in "SQL Server Management Studio" and open it
  3. Note down your "Server Name" for your own reference (in case you need to restore the current values)
  4. Replace "Server Name" with "LOCALHOST\KASDB" (Note: KASDB might be named differently, according to your initial set up)
  5. Authentication: SQL Server Authentication
  6. Login: sa || password: "Kas123!" or "kas123". These are the default credentials, if you have changed them, they will be different.
  7. Connect. If this is successful, you may proceed to the next step.

Retrieve the computer's IP address

  1. Press Start
  2. Type "CMD" and open the app
  3. Type in "ipconfig"
  4. Note down the "IPv4 Address" 
If several appear, the IP of interest typically begins with a 10.X.X.X or 192.X.X.X

Secondary Computer Steps

  1.  Launch Lock-S
  2. Under "SQL Server" input the IPv4 address from the previous step, then "\" and KASDB, and then comma ( , ) and the port opened in the Firewall configuration. Example: "10.0.10.1\KASDB,15133"
  3. Lock-S should now be able to connect to the database on the other computer.
Note: The "main" computer has to be running when attempting to open Lock-S with the secondary computer.



Recommendation: Have an IT personnel (or yourself, if you're familiar with how to do it) set up a static IP address in the DHCP for your "main" computer, to avoid the IP address changing and breaking your access from the 2nd computer.