topic Error in conncecting Azure SQL in Qlik Replicate

Error in conncecting Azure SQL

chandraprakash_j_volvo — Wed, 21 Feb 2024 08:59:38 GMT

Source Endpoint: Microsoft Azure SQL server(CDC)

I am trying to establish connection to SQL server via Active Directory Service Principal method. On first try the test connection was successful. When I retried it it failed.

This is the following error:

SYS-E-HTTPFAIL, Failed to connect.
SYS,GENERAL_EXCEPTION,Failed to connect,RetCode: SQL_ERROR SqlState: CE269 NativeError: 0 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error 12002 sending request to https://login.windows.net

Note: No firewall issues & Service Principal has been added to the sql database

Re: Error in conncecting Azure SQL

chandraprakash_j_volvo — Wed, 21 Feb 2024 09:12:03 GMT

The connection which is established is short lived. And if the connection is successfull, couldn't able to fetch the table list. It gives below error

SYS-E-HTTPFAIL, Command get_table_list failed when getting the list..
SYS,GENERAL_EXCEPTION,Command get_table_list failed when getting the list.

Re: Error in conncecting Azure SQL

Kent_Feng — Thu, 22 Feb 2024 00:19:09 GMT

Hi @chandraprakash_j_volvo

A similar issue was reported before in our community, please check this post thread: https://community.qlik.com/t5/Qlik-Replicate/Unable-to-fetch-the-list-of-table/td-p/2062444

Also this article may be helpful to you too: https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-What-Permissions-are-required-in-order-to-perform/ta-p/1938361

Thanks

Kent

Re: Error in conncecting Azure SQL

chandraprakash_j_volvo — Thu, 22 Feb 2024 07:38:44 GMT

Thanks for this article. At the same time the source endpoint disconnects intermittenly, and after sometime it connects successfully

Re: Error in conncecting Azure SQL

SushilKumar — Thu, 22 Feb 2024 11:15:41 GMT

Hello Team,

I suspect it Azure SQL is it on cloud. Request you to please check with Security /network team for Setups rules. as we have seen same issue when either of endpoint on cloud and sometime it is not able to get the response in a timely manner hence it disconnects occasionally.

Regards,

Sushil Kumar