Installing MS SQL Server source

Before you begin

It is recommended to have Talend Change Data Capture installed on the machine.

Refer to Hardware and software requirements for source databases before starting the installation of MS SQL Server source.

About this task

Procedure

When you install for the first time or add a new instance, you must specify the name of the server and the instance on which you want to install Talend Change Data Capture for MS SQL Server, and the password for the sa profile (or a profile with sysadmin role).
Select SQL Server Local in the drop-down list.
If the MS SQL Server is installed without an instance, you must leave the Instance parameter empty.
Choose the proper ODBC driver.

Results

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

An installation log is also included in the SQLServer sub-directory in the DestinationPath installation directory. It is named SQLInstall~server[@instance].log.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here