Company: Link Technologies
Case No: L12087. Project: 12.30: LinkSOFT Version 12.30
Logged By: Alvis (Link Technologies) on 20 Jul 2020 12:00AM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 6.00 (Weight: 8.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Saturday, 25 July 2020 11:59 PM [1372 days since logged date]
Status: Closed
Subject: Encrypt TNA devices "Linked Server Password" in the database

Menu: Forms-ESS/Timesheets/TimesheetDeviceSetup.aspx

Encrypt TNA devices "Linked Server Password" in the database

Audit Notes:Edited by sanjay on 25/02/21 08:51. Edited by alvis on 07/12/20 08:51. 
07 Dec 202008:34AM Comment 1 by Alvis (Link Technologies) Case L12087 added to project 12.3
07 Dec 202008:51AM Comment 2 by Alvis (Link Technologies) ETC was changed from 25/07/2020 to 25/07/2020
07 Dec 202008:52AM Comment 3 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 09-12-2020 08:50 AM Time Taken: 4.00

Development work for this case has been completed.

The change will be available in version:12.30.1204

1. The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Encrypted the TNA device linked server password
  2. Refactored code to decrypt where necessary

2. Affected Areas:

  1. TNA Device Setup

3. The issue was caused by:

  1. Improvement

4. Notes
5. Next Step


Development Reference:

24 Dec 202010:00AM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 30-12-2020 09:59 AM Time Taken: 1.00
System test completed. Proceed with UAT

24 Dec 202002:20PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 30-12-2020 02:13 PM Time Taken: 1.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
  1. Activate TNA device T1004 with the "Linked Server Password" as 8989.
  2. Edit the record to see that the password is hashed
  3. Validate that the password is encrypted in the table "LT_ESS_TimesheetImport_Devices" for company 1001. 

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.30.1224BETA
  3. Setup: Demo
  4. Server :
  5. Database: LINKSOFT-DEMO-123

Next Step

  1. For Closure

    04 Jan 202103:24PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-01-2021 03:24 PM
    Thanks Rashna 

    If you have any queries regarding this support incident, please email and include the Case No: L12087 in the subject line of all emails regarding this issue.

    Document size: 6.0 KB
    For call complaints, please contact the Managing Director of the company using this form