How to Encrypt the SQL CDR Connection Strings

Introduction

With AnywhereNow you can encrypt various individual parts of your SQL Connection String for your CDR Connection information. This allows you to encrypt the "values" part of each Connection String element (like Servername, UserId, Password, etc.) to mask them from immediate visibility on a SharePoint page, which may be visible to other users.

Find Encrypted Tokens list

1. Open your UCC config site on SharePoint

2. Open Settings (top-right)

3. Open Site contents

4. Open the EncryptedTokens list

   • The following columns should exist.

     1. Title

        1. Name: Title

        2. Type: Single line of text

     2. Key

        1. Name: wsp_ucc_et_key

        2. Type: Single line of text

     3. Value

        1. Name: wsp_ucc_et_value

        2. Type: Single line of text

Add Encrypted Token(s)

1. Open the EncryptedTokens list

2. Add + new item:

   1. Title: "Enter any unique name as a title" example: SqlCdr password 1

   2. Key: "Technical key name in {} brackets", example: {encryptedTokenKeyName1}

   3. Value: "Encrypted string of the original value" example: xoZ9HvpaP5eGPALVdZzVJA== (Created with A365.PWTool.exe)

Encrypt CDRConnectionString

Single value encrypted as token

1. Open Settings list

2. Edit CDRConnectionString

   Copy

   Connectionstring

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

3. Change to

   Copy

   Connectionstring

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

Your myPassword value is now stored in SharePoint (and the UCC) only as an encrypted value.

Multiple values encrypted as token

You can have multiple encrypted tokens in 1 connection string.

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