Premise

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
   

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.