How to connect to Azure SQL

Introduction

With Anywhere365 you can also connect to Azure SQL for your CDR information.

 

Requirements

  • Database in Azure SQL
  • Azure Admin Account
  • Whitelist IP

 

Configure

Create login for Azure SQL

  1. Connect management studio to the azure database server with the admin account (see azure)

  2. Add login for the user by submitting the following query to the master: (change username)

    CREATE LOGIN sa_username

    WITH PASSWORD = 'Password'

    GO

  3. Create a user for the database, by submitting the following query to the database

    CREATE USER sa_username FROM LOGIN sa_username;

  4. Give the user permissions, by submitting the following query to the database

    EXEC sp_addrolemember 'db_owner', 'sa_username';

    More information on:

    https://azure.microsoft.com/nl-nl/blog/adding-users-to-your-sql-azure-database/

  5. You also need permissions on the master repeat step 2 on the master database.

    Create a user for the database, by submitting the following query to the master

    CREATE USER sa_username FROM LOGIN sa_username;

 

Connect UCC to Azure SQL

  1. Navigate to the 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 page

  2. Open the Settings list

  3. Edit the setting "CDRConnectionString"

  4. Enter the connection string with username and password for Azure SQL

    Example: Server=tcp:server.database.windows.net;Initial Catalog=UCC;User ID=sa_username;Password=password