Page 1
DATABASE & NETWORK CONFIGURATION & INSTALL MANUAL
® NTC4.3.1
® NTC4.3.1

Page 2
TABLE OF CONTENTS
Database & Network Configuration & Install Manual
Introduction .......................................................................................................................................................................4
Installation Requirements ................................................................................................................................................... 5
Installing SQL Server Express .....................................................................(online at /downloads-csp.html)
Configuring SQL Server for LockView NTC ............................................................................................................................ 7
Installing LockView NTC ...................................................................................................................................................... 15
Software Licensing – Registration Wizard ............................................................................................................................. 20
Configuring LockView 4 using MS Access (standalone) ......................................................................................................... 26
Configuring LockView 4 using MS SQL (networked – Wi-Fi or Ethernet) ................................................................................... 28
Setting up the Network Module ................................................................................................................................................. 34
Network Tools ............................................................................................................................................................................ 39
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
NOTE:
The Table of Contents contains live
links. Click on any section, and
the corresponding page will load.

Page 3
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
3
TABLE OF CONTENTS continued
Other manuals available as separate pdfs:
Manual Programming of the Snap-on Level 5 Gen3 Lock
LockView NTC Instruction Manual

Page 4
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
4
INTRODUCTION
NO
NO
YES
go to
go to
YES
LockView NTC
Instruction
Manual
Setting up the
Snap-on Level
5 Gen 3 Lock
Manual
Is LockView
NTC Software
going to be
used?
Setting up the
Snap-on Level
5 Gen 3 Lock
Manual
Database
& Network
Configuration
& Installation
Manual
Will the locks
be 802.11
or Ethernet
networked?
The following chart is intended
to serve as a guide to provide
for the most logical and efficient
set-up of the Snap-on Level 5
Tool Control System.
An authorized Operator of LockView® can create a database of users and locks on a
local or networked computer. Each user in this computer's database is assigned to a
slot in each lock to which they have access. A lock's internal memory is divided into 999
slots that store user information thereby giving each lock a maximum of 999 users. That
is, 999 individuals are capable of opening the toolbox.
The computer on which LockView® is loaded has the ability to connect to locks and
update the lock's memory to correspond with its own database. It is able to gather and
manipulate a lock's audit trail, or past operation log. Audit trail information contains
the lock’s name, the name of the user attempting to gain access, the credential used, if
access was granted or denied, and the date and time of each interaction.
LockView NTC 4 works with LockServ to communicate with locks. LockServ has the ability
to communicate with multiple locks simultaneously over a network, thereby eliminating
the need for the Operator to visit each lock to update its database, or download audit
trails.
Alternately, LockServ can communicate with locks using a USB dongle if network
hardware is not available.

Page 5
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
5
64 bit compatible.
Signed 32 bit and 64 bit WHQL drivers.
Cannot use MS Access databases with network modules.
Minimum monitor resolution: 1024x768
Non-Networked Installations
LockView will use an Access DB by default.
.NET 4.0 or higher is required.
Minimum monitor resolution: 1024x768
Optional – SQL Server 2005 or better (Express versions ok). Follow LockView Client Install (in table above) for non-networked
installs.
Common Install for Non-Networked (Stand-Alone) Installations
- Laptop with LockServ installed.
- When LockView is installed it automatically creates an Access database
- The USB Dongle must be attached to a laptop and RJ11 cable from dongle to the front panel of lock to make changes to lock
or database.
- Backup of Access DB is HIGHLY RECOMMENDED.
Networked Installations
INSTALLATION REQUIREMENTS
Microsoft SQL
Server version
Operating systems supported
LockView/LockServ on SQL Server
LockView Client Install (standalone)
SQL 2005
(Express versions ok)
Minimum: 2 GB RAM
Recommended: 4 GB or higher
600 MB free space on Hard Disk
(200MB Client Install)
Pentium III Compatible or higher
Minimum: 500 MHz
Recommended: 1 GHz or higher
Windows XP Pro SP2
Windows XP Pro SP3
Windows Vista
Windows Vista SP2
Windows Server 2003 SP2
Windows Server 2003 SP3
Windows Server 2003 R2
Windows Server 2008 SP1(w/ SQL SP2)
Windows Server 2008 SP2 (w/ SQL SP2)
Windows Server 2008 R2 (w/ SQL SP2)
Windows 7
Windows XP Pro SP2
Windows XP Pro SP3
Windows Vista
Windows Vista SP2
Windows Server 2003 SP2
Windows Server 2003 SP3
Windows Server 2003 R2
Windows Server 2008 SP1
Windows Server 2008 SP2
Windows Server 2008 R2
Windows 7
SQL 2008
(Express versions ok)
Minimum: 2 GB RAM
Recommended: 4 GB or higher
2.0 GB free space on Hard Disk
Pentium III-compatible or faster
Minimum: 1.0 GHz
Recommended: 2.0 GHz or faster
Windows XP Pro SP2
Windows XP Pro SP3
Windows Vista
Windows Vista SP2
Windows Server 2003 SP2
Windows Server 2003 SP3
Windows Server 2003 R2
Windows Server 2008 SP1
Windows Server 2008 SP2
Windows Server 2008 R2
Windows 7
Windows XP Pro SP2
Windows XP Pro SP3
Windows Vista
Windows Vista SP2
Windows Server 2003 SP2
Windows Server 2003 SP3
Windows Server 2003 R2
Windows Server 2008 SP1
Windows Server 2008 SP2
Windows Server 2008 R2
Windows 7

Page 6
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
6
If SQL is used refer to the following ‘Common Install for Networked Installations’ list.
Common Install for Networked Installations:
- Server/PC with SQL Server and setup to be the LockView Server and a laptop with LockView Client Installed.
- Backup of SQL Server is HIGHLY RECOMMENDED.
Note:
Network module must be programmed to point to the IP address of the computer with LockView Server (LockServ) installed.
All LockView Clients must also be able to connect to the LockView SQL DB through ODBC.
Network Modules need to be setup/changed with the USB dongle and RJ11 cable through the panel. This is the main reason a
Laptop with LockView Client is suggested. See pages 28-36 for setup.
There should only be one computer set up to be the LockView Server.
There should only be one LockView SQL Database.
LockView Clients and Server must have Local Administrator Rights on the computer on which they are setup.
How the Network Modules work with SQL and LockView.
- The Network Modules must be setup to communicate with the Server through its IP Address. This can be set in LockView with
the USB Dongle in the LockView options menu.
- The Server IP Address programmed in the network modules is the computer that is set up to be the LockView server.
- LockView Server installs a service that runs automatically called LockServ
- LockView Clients install the same LockServ. LockServ runs only when the LockView program is running.
- LockServ must be running on the LockView Server for the Network Modules to update to the Database.
- LockView must have a valid ODBC setup to the SQL database to connect.
INSTALLATION REQUIREMENTS continued

Page 7
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
7
On the computer configured with Microsoft SQL Server Management Studio, go to Start - All Programs - Microsoft SQL Server
- open Microsoft SQL Server Management Studio
1. Select the SQL Instance where the lvServer db will be installed.
2. Click File - Open - File
CONFIGURE MS SQL SERVER FOR LOCKVIEW NTC 4

Page 8
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
8
3. Navigate to the script “LVServer_4_3_1_dbCreate.sql” (on the install cd and (once installed) can be found typically at C:\
Program Files\LockView4\SQL Script) then click Open
4. Click Execute – Be sure that ‘master’ is the db selected in this box.
CONFIGURE MS SQL SERVER FOR LOCKVIEW NTC 4 cont.

Page 9
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
9
5. After a few seconds, the script runs and three (1 row(s) affected) messages will be displayed. Click F5 (to refresh the screen)
6. Click the + sign next to databases, the lvServer database will be displayed. Right click lvServer database and select Properties
CONFIGURE MS SQL SERVER FOR LOCKVIEW NTC 4 cont.

Page 10
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
10
CONFIGURE MS SQL SERVER FOR LOCKVIEW NTC 4.1 cont.
7. Click Options
8. Change the AutoShrink option from False to True, then click OK.

Page 11
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
11
CONFIGURE MS SQL SERVER FOR LOCKVIEW NTC 4.1 cont.
9. Right Click on the Server\(Instance Name) – Click Properties

Page 12
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
12
CONFIGURE MS SQL SERVER FOR LOCKVIEW NTC 4.1 cont.
10. Select Connections and Check the box “Allow remote connections to this server.” Click OK. Close out of the Microsoft SQL
Management Studio

Page 13
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
13
CONFIGURE MS SQL SERVER FOR LOCKVIEW NTC 4.1 cont.
11. Open SQL Server Configuration Manager
12. Make sure SQL Server Browser Service is enabled and running. Also be sure that SQL Server (Instance Name) is enabled and
running. Start Mode should be Automatic for the SQL Browser Service and SQL Server.

Page 14
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
14
CONFIGURE MS SQL SERVER FOR LOCKVIEW NTC 4.1 cont.
13. Click on SQL Server Network Configuration, click on ‘Protocols for (Instance Name).’ Enable TCP/IP, Named Pipes, and
Shared Memory.
14. Open SQL Native Client 10.0 Configuration, Click Client Protocols, enable Shared Memory, TCP/IP, Named Pipes. Close out
of SQL Server Configuration Manager.

Page 15
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
15
Note: The person installing and operating LockView must have ADMINISTRATIVE RIGHTS on the computer where LockView will
be installed.
Insert LockView4 CD
If the LockView Software did not
autorun:
- Select Windows START button in
bottom left corner of screen.
- Select RUN
- Select BROWSE
- Look in the appropriate CD ROM
drive
- Select the “Autorun.exe file”
1. Install Shield will prepare to install.
2. Click Next
INSTALL LOCKVIEW 4

Page 16
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
16
INSTALL LOCKVIEW 4 continued
3. Click Next
4. Read agreement, if acceptable,
click I accept the terms in this
agreement, then click Next

Page 17
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
17
INSTALL LOCKVIEW 4 continued
5. Click Next
(It is not recommended to
install LockView at different
locations other than the
default.)
6. Select ‘Install LockView Server’
for server install and “Install
LockView client” for client install,
then click Next.
Note:
- If this is a Standalone or MS
Access installation, select Install
LockView Client.
- LockView Server should only be
selected if this is the main lock
server.
- There should only be one LockView
Server for Networked installs.
- Multiple LockView Clients maybe
installed.
- Non-Networked installs only
require LockView Client

Page 18
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
18
INSTALL LOCKVIEW 4 continued
7. Click Next
8. Click Install

Page 19
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
19
INSTALL LOCKVIEW 4 continued
9. Installation begins
10. Click Finish
Continue to document:
Configure LockView for
SQL (pages 28-33)
Or
Configure LockView for
Access (pages 26-27)
11. Restart computer.
12. After the reboot is completed
here is the LockServ Icon that will
be in the toolbar. If LockView was
installed as a Server, LockServ
will be run as a service and
the icon will always be present.
If LockView was installed as a
Client, the LockServ icon will
only be displayed when LockView
is open.

Page 20
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
20
1. If connected to the internet or have email on the computer, please click on Electronic Registration.
If not, please call the CompX Technical Support Line 847-752-2525 between 8 am and 5 pm Monday - Friday and have the CD
serial number and Site Code available.
SOFTWARE LICENSING - REGISTRATION WIZARD

Page 21
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
21
2. LockView Registration Wizard – Please enter the 12 digit serial number located on the back of the LockView CD case. Spaces
are required. Click Next
3. Please fill out the Registration information. Fields with an * are required.
4. Once the registration information is finished, the wizard will attempt to connect to the internet and register the software. If the
software was registered successfully the following screens will appear.
Click Finish
SOFTWARE LICENSING - REGISTRATION WIZARD continued

Page 22
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
22
5. If an error is received the LockView Server could not be reached. An email can be sent to register LockView. Click OK on the Error
message and the wizard will attempt to send an email to the Registration Server.
SOFTWARE LICENSING - REGISTRATION WIZARD continued

Page 23
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
23
Click Next
6. Click Yes when prompted to allow an email to be sent.
SOFTWARE LICENSING - REGISTRATION WIZARD continued

Page 24
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
24
Click Finish to close the LockView Registration Wizard.
7. An email will be sent the registered email address.
Copy the Site Key from the email and paste into the Site Key field within the LockView Software Licensing screen.
SOFTWARE LICENSING - REGISTRATION WIZARD continued

Page 25
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
25
Click Validate to ensure the software is properly licensed.
NOTE: If it becomes necessary to transfer the license to a different computer, a new Site Key will be required. Click on Return
License to initiate this process.
SOFTWARE LICENSING - REGISTRATION WIZARD continued

Page 26
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
26
CONFIGURE LOCKVIEW4 FOR MS ACCESS (STANDALONE)
1. Double click the shortcut LockView4 icon found on the desktop. If using Windows 7 or Windows Server 2008, right click and
select “Run As Administrator.”
2. Click Yes
3. Click the down arrow next to Create/Edit DSN and Select LockView4.
Click OK.
Alternatively: The LockView/LockServ database selection and port
number can be changed with lsConfig.
lsConfig is located in C:\Program Files\LockView4.
Note: This is not common, but this is needed if LockView is not installed
and only LockServ is installed.

Page 27
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
27
CONFIGURE LOCKVIEW4 FOR MS ACCESS (STANDALONE) cont.
4. LockView will now open. Login using the default username and password.
Operator Name – admin
Password – admin
Click OK

Page 28
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
28
Note: For standalone install with Access database, go to page 26.
1. Double click the shortcut LockView4 icon found on the desktop. If using Windows 7 or Windows Server 2008, right click and
select “Run As Administrator.”
2. Click Yes
3. Click Create / Edit DSN
CONFIGURING LOCKVIEW FOR SQL

Page 29
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
29
4. Click the System DSN tab then click Add
5. Select SQL Server, then click Finish
CONFIGURING LOCKVIEW FOR SQL continued

Page 30
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
30
CONFIGURING LOCKVIEW FOR SQL continued
6. Enter in the following information
Name:
LockView4-MSSQL
Description:
LockView4-MSSQL
Server:
(Server Name)\(Instance Name)
Note: For LockView4 to read an ODBC source it MUST start EXACTLY (case sensitive) with [LockView4-] – no brackets.
MSSQL is an example, any name may be used, provided it starts LockView4-.
Then click Next
7. Verify settings, then click Next

Page 31
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
31
CONFIGURING LOCKVIEW FOR SQL continued
8. Select “Change the default database to” then from the drop down box, select lvServer, then click Next.
9. Click Finish

Page 32
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
32
CONFIGURING LOCKVIEW FOR SQL continued
10. Click Test Data Source
11. Click OK
Close all open Windows

Page 33
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
33
CONFIGURING LOCKVIEW FOR SQL continued
12. From the desktop again, launch LockView4
Click Yes
13. From the dropdown list select MSSQL or whatever the DSN was named in step 6. Default is MSSQL. LockView4 in this example
is the default Access Database that was created with LockView4 Install.
Alternatively: The LockView/LockServ database selection and port
number can be changed with lsConfig.
lsConfig is located in C:\Program Files\LockView4.
Note: This is not common, but this is needed if LockView is not installed
and only LockServ is installed.
14. Login using default username and password:
Operator Name = admin
Password = admin
Click OK.

Page 34
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
34
The following information is required to setup the network module.
◆ The IP Address of the Lock Server (most likely the same Server as the SQL Server)
◆ The SSID of the wireless access points on the network where the system is being installed (if using 802.11g wireless module)
◆ The type of wireless security enabled on the wireless access point, as well as the password
To verify the IP address of the LockView 4 Lock Server, follow the steps below:
1. Go to Start - Run on the Lock Server computer.
2. Type cmd, then press OK
SETTING UP THE NETWORK MODULE

Page 35
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
35
3. Type ipconfig
4. Write down the IP Address for the Lock Server computer, then close this cmd window
5. Attach a Snap-on GEN 3 dongle to a USB port of the computer.
SETTING UP THE NETWORK MODULE continued

Page 36
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
36
SETTING UP THE NETWORK MODULE continued
6. The USB Driver should be installed during LockView install and will install automatically when the dongle is plugged in.
If needed for reinstall, the drivers can be downloaded at /lockview/drivers.html, LockView CD
or C:\program files (x86) \ LockView 4\.
7. With the USB dongle attached, the Read / Write
Lock icon turns Green. Click Settings.
8. Route 6wire RJ11 cable from USB dongle to lock.
9. If the lock has a network module and it needs to be
configured, click Wireless Module Configuration.
If the lock has a CAT5 Ethernet and it needs to be
configured, click Ethernet Module Configuration.
For this example we are setting up a Wireless
Module using DHCP and WPA2:

Page 37
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
37
SETTING UP THE NETWORK MODULE continued
10. For this example, DHCP is selected. Alternately, a static IP address can be assigned to each lock. Extreme care must be used to
ensure unique IP addresses.
Enter in the SSID of the wireless network or Click ‘Available SSIDs’ to search.
Enter the Lock Server IP address (obtained on page 35)
Enter the TCP/IP port number of 4308
Select and enter the appropriate WIFI security protocol and password.

Page 38
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
38
SETTING UP THE NETWORK MODULE continued
11. Once all settings have been entered, click Save Settings to Module.
The software will then connect to the lock. This is noted by a status bar near the bottom of the screen as well as the connection
status will change in the upper right corner of the window.
12. If using Enterprise Security with Certificates, please reference the Certificate Help Page.

Page 39
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
39
LockView is provided with a set of network tools to help diagnose network / IP address / Wi-Fi / Database problems. To use,
click on Settings:
With the USB Dongle attached to the laptop, attach the RJ11 cable to the front of the panel of the lock and to the USB
Dongle. Select the type of Network Module provided - Click either:
- Wireless Module Configuration
(In this example Wireless Module Configuration is chosen)
To use network tools on a lock with a wireless module
– OR –
- Ethernet Module Configuration
To use network tools on a lock with an ethernet module
NETWORK TOOLS

Page 40
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
40
NETWORK TOOLS continued
At the bottom of this screen there are a few options.
- Show Most Recent Settings - Shows the most recent settings that were saved to a module.
- Show Module Settings – Connects to the Wireless/Ethernet module and displays current settings.
- Test Connection – Runs various tests to confirm that the current settings are able to connect to the network, the Lock Server,
and the database. It will also show the currently assigned IP Address and MAC Address of the module.
- Save Settings to Module – Allows changes to be saved to module.

Page 41
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
41
NETWORK TOOLS continued
Test Connection
1. Click on Test Connection within Wireless/Ethernet Module Configuration
2. A Connection Status window will pop-up and start communicating with the
module
3. A pop-up then requests that the RJ11 cable is disconnected. Hit the ‘Up’ button on the front of the lock access panel to initiate
a network connection and lock update.

Page 42
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
42
NETWORK TOOLS continued
4. Once the “ACCESS” indicator has stopped flashing on the keypad
display, reconnect the cable and hit ‘OK.’
If there is a failure at any time, click “Analyze Failure” for possible
solutions to the problem.
5. If a test fails, select ‘Analyze Failure.’
Here is a list of possible problems and what to check:
Update Issue
What went wrong: The database did not update when the lock called
in.
What to check: Ensure the databases selected here and on the
server are the same.
Missing Records
What went wrong: The database does not contain data for this lock.
What to check: Ensure the databases selected here and on the
server are the same.
Communication Glitch
What went wrong: Data was lost or corrupted during communication
with the lock/module.
What to check: This is not a network issue, but an internal dataflow
error; ensure cabling is intact and try retesting.
Socket Issue
What went wrong: The wireless module could not open a TCP socket
to the server.
What to check: First, retest; failing that, ensure the server is configured
to accept incoming connections on the designated port.
PING Issue
What went wrong: The server did not respond to a PING from the
module.
What to check: First, retest; failing that, ensure the module was
programmed with the correct server IP.
Server Undefined
What went wrong: The server IP and Port parameters are not known.
What to check: Has this module been programmed? If so, the
programming may have failed to take. Return to Configuration
screen, ‘Save Settings to Module’ again, and ensure the save reports
success.
DHCP Issue
What went wrong: The module did not get an IP dynamically assigned.
What to check: First, retest; failing that, re-evaluate the module
settings; it was not able to gain network access.

Page 43
LockView® NTC 4 Operator’s Manual – Database & Network Configuration & Install Manual
43
LockServer Activity Monitor
Once locks are setup properly they ‘check-in’ to the
lock server through the Activity Monitor.
Click ‘LockServer Activity Monitor’
The LockServer Activity screen will pop-up.
As locks connect to the lock server, their lock name and
serial number appear in the window.
NETWORK TOOLS continued

Page 44
DATABASE AND NETWORK CONFIGURATION AND INSTALL MANUAL
Copyright 2011 © CompX Security Products
Any companies and/or products referred to herein are marks or registered trademarks of their respective companies, owners and/or mark holders.
® NTC4.3.1
® NTC4.3.1