How to encrypt connection strings

Introduction

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

 

Requirements

 

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 Contact Center has its own settings, interactive voice response questions and Agent with specific skills. Agents can be member of, or sign up to, one or more Contact Centers. 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};