topic Re: Amazon RDS for SQL server as a source - defining additional connection properties in Qlik Replicate

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

sujankudumula — Wed, 19 Jun 2024 17:26:24 GMT

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'

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

Kent_Feng — Thu, 20 Jun 2024 00:03:23 GMT

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

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

john_wang — Thu, 20 Jun 2024 01:10:57 GMT

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.

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

Kent_Feng — Thu, 20 Jun 2024 01:26:08 GMT

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.

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

sujankudumula — Thu, 20 Jun 2024 19:57:49 GMT

Thank you Kent and John.