Setting Up a Microsoft Azure SQL-Based Translation Database

This section describes how to set up a Microsoft Azure SQL database to use with the Connector. For information on database size requirements, see Translation Database Size Requirements.

  1. Create an empty Azure database. For detailed instructions, refer to the Microsoft Azure documentation.

Recommendation: Name the new database CT3Translation.

Note: Set your default database collation to SQL_Latin1_General_CP1_CI_AS.

  1. Configure the Connector database connection string. The Website_root/App_Config/ConnectionStrings.config file defines the database connections.

Important: The database part of the connection string must match the database name you created in the previous step.

Typically, it should be:

<?xml version=“1.0” encoding=“utf-8”?>

<connectionStrings>

<add name=“core” connectionString=“user id=xxx;password=xxxt;Data Source=xxx;Database=XXX_Core”/>

<add name=“master” connectionString=“user id=xxx;password=xxxt;Data Source=xxxx;Database=XXX_Master”/>

<add name=“web” connectionString=“user id=xx;password=xxx;Data Source=xxx;Database=XXX_Web”/>

</connectionStrings>

You must add one more connection string called CT3Translation for the Connector database. This is the name of the database from above:

<add name=“CT3Translation” connectionString=“Data Source=tcp:SERVER.database.windows.net;Initial Catalog=DB_NAME;Integrated Security=False;User ID=USER_NAME@SERVER;Password=PASSWORD;Encrypt=True”/>

For example:

<add name=“CT3Translation” connectionString=“Data Source=tcp:mpr0fb9mzh.database.windows.net;Initial Catalog=CTT;Integrated Security=False;User ID=CTT@mpr0fb9mzh;Password=csct@blet99;Encrypt=True”/>

Note: Do not use any name other than CT3Translation for the connection string.

The User ID, Password, and Data Source values are usually the same as those used for the other connection strings.

Note: The user specified in the connection string must have permission to modify the table structure in the database. This user must have permission to run ALTER TABLE statements.