Dialogue Cloud

Connecting to Azure SQL

Note: Azure Private Link is not supported.

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

Prerequistes

  • Existing Azure SQL database

  • Azure Administrative Account

  • Allowed IP

Creating an account

You can choose between:

  • SQL Account

  • Active Directory account

    Note: Only supported for Core service.

Below the manuals on how to create both of them. (Only one is needed).

Creating an Azure SQL Account

  1. Connect SQL Server Management Studio (SSMS) to the azure database server with the admin account (see azure).

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

    Note When creating a login or a password make sure it does NOT contain the following characters: # $ [] () , ; ? * ! @ = . % &

    Copy
    SQL
    CREATE LOGIN sa_username
    WITH PASSWORD = 'Password'
    GO
    CREATE USER sa_username FROM LOGIN sa_username;
  3. Create a user for the database and give permissions, by submitting the following query to the CDR database

    Copy
    SQL
    CREATE USER sa_username FROM LOGIN sa_username;
    EXEC sp_addrolemember 'db_owner', 'sa_username';

More information on:

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

Create Active Directory Account for Azure SQL

  1. Set Active Directory Admin from with the Azure Portal

  2. Connect to server via SQL Server Management Studio (SSMS) with account set on step 1

    Use the ‘Active Directory – Universal with MFA support’ authentication method.

    Choose for Connect (and optionally follow the MFA steps to complete the login)

  3. Run the following queries

    1. Run this query against the Master (instance):

      Copy
      SQL
      CREATE USER "<AAD user address>" FROM EXTERNAL PROVIDER;
      ALTER ROLE dbmanager ADD MEMBER [AAD user address];

      (e.g.

      CREATE USER "user@anywhere365.net" FROM EXTERNAL PROVIDER;)

      ALTER ROLE dbmanager ADD MEMBER [user@anywhere365.net]; )

    2. Run this query against the UCC A Unified Contact Center, or UCC, is a queue of interactions (voice, email, IM, etc.) that are handled by Agents. Each UCC has its own settings, IVR menus and Agents. Agents can belong to one or several UCCs and can have multiple skills (competencies). An UCC can be visualized as a contact center “micro service”. Customers can utilize one UCC (e.g. a global helpdesk), a few UCC’s (e.g. for each department or regional office) or hundreds of UCC’s (e.g. for each bed at a hospital). They are interconnected and can all be managed from one central location. database:

      Copy
      SQL
      CREATE USER "<AAD user address>" FROM EXTERNAL PROVIDER;
      EXEC sp_addrolemember 'db_owner', "<AAD user address>";

      (e.g.

      CREATE USER "user@anywhere365.net" FROM EXTERNAL PROVIDER;)

      EXEC sp_addrolemember 'db_owner', “user@anywhere365.net";)

 

Connect UCC to Azure SQL

  1. Navigate to the UCC 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 AD Account:

    Copy
    Connection string
    Server=tcp:server.database.windows.net;Initial Catalog=UCC;Persist Security Info=False;User ID=sa_username;Password=password;Encrypt=True;TrustServerCertificate=False;Authentication="Active Directory Password";

    Example SQL Account:

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