# Installing MS Azure SQL source

## Before you begin

Refer to [MS Azure SQL requirements](https://help.qlik.com/talend/en-US/change-data-capture-installation-guide/7.3/requirements-ms-azure-sql) before starting the installation.

Information noteNote: In case of an update:

* With Talend Change Data Capture versions prior to 7.17.0, make sure all previously installed services are uninstalled. Go to DestinationPath > SQLServer and click ddUniversalSqlServer\_uninstall.cmd, ScheduleSQLServer\_uninstall.cmd and SPVSQLServer\_uninstall.cmd. ![](https://help.qlik.com/talend/en-US/change-data-capture-installation-guide/Resources/images/tcdc-azure-uninstall-current-services.png)
* Now you can delete SQLServer folder.
* From the Registry Editor, go to HKEY\_CURRENT\_USER\SOFTWARE\WOW6432Node\Gammasoft\DataDistribution and delete DD\_for\_SQLServer folder.

## Procedure

1. Launch setup.exe and click Install > Click to install.
2. Select SQL Server Source.
3. Once the MS SQL Server Source is deployed, you need to define the fields of the Login window as follows:
   * Server: alias name, as defined in C:\windows\syswow64\cliconfg.exe tool.
   * Database: name of the database stored in MS Azure DB SQL Server.
   * Select Azure SQL Server DB in the drop-down list.
   * User Name: user@servername, as entered in cliconfg.exe tool.
   * Password: password of the Azure account user.
   * Driver: select an ODBC driver version that is higher or equal to 17 for SQL Server.

     Information noteNote: Do not select the Native Client ODBC driver.

   ![](https://help.qlik.com/talend/en-US/change-data-capture-installation-guide/Resources/images/tcdc-install-azure-sql-server-source.png)

## Results

Talend Change Data Capture then creates and installs the elements required by MS Azure SQL.

At the end of the installation, the following message is displayed: Setup was completed successfully.

Once MS Azure SQL source is installed, you can check the connection to the source database using the alias. Then launch Talend Change Data Capture Manager and subscribe to it. See [Managing sources](https://help.qlik.com/talend/r/en-US/7.3/change-data-capture-user-guide/managing-sources) for more details.

Information noteWarning: As this Talend Change Data Capture source relies on an intermediate layer (Microsoft SQL Server CDC), the use of databases is pooled. Be careful when activating or deactivating the journalization and replication processes, as they will be shared with the other users.