This article discusses SQL account usage and password changes needed when a user wants to use their own custom passwords for the SQL accounts used by WaspTime.
 
The SQL account sa is used when creating or patching the database.

The SQL account TimeUser is used for communication between the SQL database and the PC Clients, and the WaspTime Server Service (WTSS).
 
The SQL account TimeReader is used by the Crystal Reports viewer (for running reports).

Places where the password must be updated:

1. WTSS PC's registry needs the encrypted password for TimeUser:
64-bit Windows: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Wasp Technologies\WaspTime5\Options\DatabasePassword
32-bit Windows: HKEY_LOCAL_MACHINE\SOFTWARE\Wasp Technologies\WaspTime5\Options\DatabasePassword

2. SQL Accounts (TimeUser, TimeReader) need new passwords specified via SQL Server Management Studio in cleartext)

If you need to use custom passwords, Wasp Tech Support will need your desired passwords so we can generate and send you the corresponding encrypted passwords. The maximum number of characters for each password is 20.