20 Dec 2024 3 min read

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 ...

Lock-S installation

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

Main computer fully configured and installed as per the instructions in this article.
Admin privileges and passwords on both computers
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

Press Start
Type in "SQL server configuration manager"
Launch and proceed to the next step

If it does not appear under your apps, instead go to:

"C:WindowsSysWOW64" and locate "SQLServerManager11" in the files there.

Configuring with the SQL Server Configuration Manager

Locate "SQL Server Network Configuration" on the left-hand window (Fig. 1)
Select "Protocols for KASDB" (Note: KASDB might be named differently, according to your initial set up)
Double-Click "TCP/IP"
Change "Enabled" to "Yes"
Select the "IP Addresses" tap
Scroll all the way down to "IPAII"
Select "TCP Dynamic Ports" and type in the port you wish to use (e.g. 15133)
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

Press Start
Type in "Defender Firewall" and open the app
Select "Advanced Settings"
Right Click "Inbound Rules" and "New Rule"
In the "Rule Type" window select "Port" and click Next
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

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

Retrieve the computer’s IP address

Press Start
Type "CMD" and open the app
Type in "ipconfig"
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

Launch Lock-S
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.1KASDB,15133"
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.