Amazon RDS for SQL server as a source - defining additional connection properties

[sujankudumula]

Amazon RDS for SQL server as a source endpoint, I need to define the additionalConnectionProperties for below parameters. 

Encrypt=True;trustServerCertificate=false

I tried as is and I get below error.

• SYS-E-HTTPFAIL, Failed to connect.
• SYS,GENERAL_EXCEPTION,Failed to connect,RetCode: SQL_ERROR SqlState: 08001 NativeError: 0 Message: [Microsoft][ODBC Driver 17 for SQL Server]Invalid value specified for connection string attribute 'Encrypt'

[Kent_Feng]

Hi @sujankudumula 

Please try the other two internal parameter instead of additionalConnectionProperties:

• useEncryptedConnection
• useTrustServerCertificate

By default they are not ticked, just tick useEncryptedConnection as you need encrypted connection.

There is also another IP that you may need:

• useTrustedConnection

Hope this helps.

Regards

Kent

[john_wang]

Hello @sujankudumula ,

In addition to @Kent_Feng comment, I'm not sure what's the Qlik Replicate version you are running now, however ODBC Driver Version 17.x is for previous Replicate Versions. Please confirm you installed the certified ODBC Driver Versions .

Regards,

John.

[Kent_Feng]

Thanks @john_wang , yes Replicate needs Microsoft ODBC Driver 18.1 (no older or newer) for SQL Server based endpoints from version 2022.11 to the latest release 2024.05. If your Replicate is still 2022.05, you can use Microsoft  ODBC Driver 17.6 or 17.2.0.1.

[sujankudumula]

Thank you Kent and John.