We are attempting to connect to the same MS SQL Server in an application automation that we already connect to in the Qlik Cloud Analytics side. We receive the following error:
SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2746
- This is using the built in "Microsoft SQL Server" connection in Application Automation, then evaluating with a "Do query" block in an automation
- We are using the same IP and port as our connection on the analytics side
- Same username, password, database name, and encryption settings (no encryption)
- TCP/IP is configured on the SQL Server and configured to port 1433
- TLS 1.2 is configured (we have also successfully tested connection from analytics side with TLS 1.2)
- We have whitelisted incoming 1433 traffic on the SQL Server from incoming IPs mentioned in this documentation: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-... (We know we got the right ones because before doing this, we were receiving a login timeout, now we get the above error almost immediately after triggering automation)
When Googling the error code, all signs point to either TLS 1.2, TCP/IP configuration in SQL Server, or credential issues. We have eliminated all these factors, yet it seems that the exact same values work in a SQL connection on the analytics side but not on the automation side. Is there anything else we can check?
