How to encrypt connection strings


With Anywhere365 you can also encrypt your connection string for your CDR information.




Create Encryped Token list

  1. Open your UCCUCC stands for Unified Contact Center and consists of a queue that can be handled by Agents. Each UCC has its own settings, interactive voice response questions and Agents with specific skills. Agents can be member of, or sign up to, one or more UCCs. config site on SharePoint
  2. Open Settings (top-right)
  3. Open Site contents
  4. Select Add an App
  5. Select Custom List
  6. Enter EncryptedTokens as name
  7. Select Create
  8. Open the EncryptedTokens list
  9. Add the following columns. (You can change the name later)
    1. Key
      1. Name: wsp_ucc_et_key
      2. Type: Single line of text
    2. Value
      1. Name: wsp_ucc_et_value
      2. Type: Single line of text


Add Encrypted Token

  1. Open the EncryptedTokens list
  2. Add new item:
    1. Title: "Whatever you find suitable for a title"
    2. Key: {encryptedTokenKeyName}
    3. Value: xoZ9HvpaP5eGPALVdZzVJA== (Created with A365.PWTool.exe)


Encrypt CDRConnectionString

  1. Open Settings list

  2. Edit CDRConnectionString

    Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

  3. Change to

    Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password={encryptedTokenKeyName};


Your password is now encrypted.

You can have multiple encrypted tokens in 1 connection string.

Server={encryptedTokenKeyName1};Database={encryptedTokenKeyName2};User Id={encryptedTokenKeyName3};Password={encryptedTokenKeyName4};