• Areas Impacted by Encryption
• Encrypted Columns
• EncryptGui Tool Overview
• Master Key Encryption
  • Creating an Encryption Database Connection String without Master Keys
  • Creating an Encryption Database Connection String with Master Keys
  • Modifying Master Keys
• Key Ring Tab
  • Encrypting a Column and Related Audit Columns
  • Modifying Column Keys
  • Deleting Column Keys
• Generating a Password
• Options Tab
• Initializing the Application
• Verifying Encryption
• ID TECH Payment Device Encryption (AudienceView 6.8.11)

From the Master Keys tab in the AudienceView EncryptGui window is where you encrypt your database connection string with keys, which is found in the global.asa file.

The following steps describe how to encrypt a connection string with keys:

1. Create a back-up of the database.
2. Under the AudienceView directory, go to the ..\libs directory.
3. Click the EncryptGui icon.
   
4. Run the application.
   The AudienceView EncryptGui window will open.
   
5. Click 'Master Keys: Blank'.
   A pop-up window will display.
   To generate master keys, refer to Generating a Password.
   
6. Enter and verify Master Key 1.
7. Click 'OK'.
   A second pop-up window will display.
   
8. Enter and verify Master Key 2.
9. Click 'OK'.
   The 'Master Keys: Blank' button text will change to 'Master Keys: Entered'.
   
10. Click 'Apply New Master Keys'.
11. Enter your connection string in the large edit box.
12. Click 'Encrypt'.
13. Copy the result from the lower edit box to the global.asa.
    An encrypted string can be decrypted the same way as described above, except using the 'Decrypt' button.