Essl Etimetracklite Server -

Open the (usually found in the installation folder or start menu). Select MS SQL Server as your database type.

Configure weekly or daily scheduled backups within SQL Server Management Studio to prevent catastrophic data loss.

The eSSL eTimeTrackLite Server relies on a standard three-tier architecture to ensure scalability and security:

Install MS SQL Server and create a blank database for the software.

Before initiating the installation, ensure your server environment meets the following minimum requirements to guarantee smooth performance: Hardware Requirements essl etimetracklite server

Schedule daily or weekly automated backups of your SQL database. Biometric log data grows rapidly and can cause performance drops if unmanaged.

: Allows administrators to manage thousands of devices and upload/delete users across multiple terminals simultaneously. eSSL- eTime Track-Lite Web

Complete the installation and restart your system if prompted. Step 2: Create the SQL Database Open . Right-click on Databases and select New Database . Name the database (e.g., eTimeTrackServer ) and click OK .

Select your authentication method. If using , input your sa username and password. Select eTimeTrackLiteDB from the database dropdown menu. Click Test Connection . Once successful, click Save . 4. Connecting Biometric Devices to the Server Open the (usually found in the installation folder

Periodically shrink your SQL database log files ( .ldf ) to free up server storage space.

To avoid manual downloads of punch data every evening, you must configure the background service.

Generates detailed attendance reports to streamline the payroll process.

Install and configure Internet Information Services (IIS) on the server. The eSSL eTimeTrackLite Server relies on a standard

Use eSSL's push data technology. Input the server’s public URL or domain name directly into the device's "Cloud Server" settings. The device will then automatically "push" logs to the server over standard HTTP/HTTPS ports. Configuring the Device Management Service

SQL Server not allowing remote connections (even locally). Fix: Open SQL Server Management Studio > Server Properties > Connections > Check "Allow remote connections to this server" .

SSD with at least 50 GB of free space (scales with database growth). Software Prerequisites

| Feature | eTimeTrackLite Server (On-Prem) | Cloud Solutions (e.g., Zoho People, greytHR) | | :--- | :--- | :--- | | | None (works on LAN) | 100% dependent on broadband | | Monthly Cost | One-time license fee | Recurring per-employee/month fee | | Data Privacy | Data stays on your PC | Data stored on vendor’s servers (GDPR risk) | | Remote Access | Difficult (needs VPN) | Easy via web browser | | Device Compatibility | Works only with ESSL hardware | Works with any device via mobile app | | Auto Backup | You manage it | Vendor manages it |