https://community.qlik.com/t5/Qlik-Automate/Unable-to-connect-to-MS-SQL-Server/m-p/2086885#M2074 <P>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.&nbsp; We receive the following error:&nbsp;<BR /><BR /></P> <DIV class="json-header" data-v-05a469cc=""> <DIV class="json-key" data-v-05a469cc="" data-testid="json-viewer-key"><STRONG>error:</STRONG></DIV> </DIV> <DIV class="json-value" data-v-05a469cc=""><STRONG>SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2746 </STRONG></DIV> <DIV class="json-value" data-v-05a469cc="">&nbsp;</DIV> <UL> <LI class="json-value"><SPAN data-v-05a469cc="">This is using the built in "Microsoft SQL Server" connection in Application Automation, then evaluating with a "Do query" block in an automation</SPAN></LI> <LI class="json-value"><SPAN data-v-05a469cc="">We are using the same IP and port as our connection on the analytics side</SPAN></LI> <LI class="json-value"><SPAN data-v-05a469cc="">Same username, password, database name, and encryption settings (no encryption)</SPAN></LI> <LI class="json-value"><SPAN data-v-05a469cc="">TCP/IP is configured on the SQL Server and configured to port 1433</SPAN></LI> <LI class="json-value"><SPAN data-v-05a469cc="">TLS 1.2 is configured (we have also successfully tested connection from analytics side with TLS 1.2)</SPAN></LI> <LI class="json-value"><SPAN data-v-05a469cc="">We have whitelisted incoming 1433 traffic on the SQL Server from incoming IPs mentioned in this documentation: <A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-dns-ip.htm" target="_blank">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-dns-ip.htm</A>&nbsp;(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)</SPAN></LI> </UL> <P><SPAN data-v-05a469cc="">When Googling the error code, all signs point to either TLS 1.2, TCP/IP configuration in SQL Server, or credential issues.&nbsp; 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.&nbsp; Is there anything else we can check?</SPAN></P> Thu, 22 Jun 2023 15:02:36 GMT matthewharrison 2023-06-22T15:02:36Z https://community.qlik.com/t5/Qlik-Automate/Unable-to-connect-to-MS-SQL-Server/m-p/2086885#M2074 <P>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.&nbsp; We receive the following error:&nbsp;<BR /><BR /></P> <DIV class="json-header" data-v-05a469cc=""> <DIV class="json-key" data-v-05a469cc="" data-testid="json-viewer-key"><STRONG>error:</STRONG></DIV> </DIV> <DIV class="json-value" data-v-05a469cc=""><STRONG>SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2746 </STRONG></DIV> <DIV class="json-value" data-v-05a469cc="">&nbsp;</DIV> <UL> <LI class="json-value"><SPAN data-v-05a469cc="">This is using the built in "Microsoft SQL Server" connection in Application Automation, then evaluating with a "Do query" block in an automation</SPAN></LI> <LI class="json-value"><SPAN data-v-05a469cc="">We are using the same IP and port as our connection on the analytics side</SPAN></LI> <LI class="json-value"><SPAN data-v-05a469cc="">Same username, password, database name, and encryption settings (no encryption)</SPAN></LI> <LI class="json-value"><SPAN data-v-05a469cc="">TCP/IP is configured on the SQL Server and configured to port 1433</SPAN></LI> <LI class="json-value"><SPAN data-v-05a469cc="">TLS 1.2 is configured (we have also successfully tested connection from analytics side with TLS 1.2)</SPAN></LI> <LI class="json-value"><SPAN data-v-05a469cc="">We have whitelisted incoming 1433 traffic on the SQL Server from incoming IPs mentioned in this documentation: <A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-dns-ip.htm" target="_blank">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/qlik-cloud-dns-ip.htm</A>&nbsp;(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)</SPAN></LI> </UL> <P><SPAN data-v-05a469cc="">When Googling the error code, all signs point to either TLS 1.2, TCP/IP configuration in SQL Server, or credential issues.&nbsp; 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.&nbsp; Is there anything else we can check?</SPAN></P> Thu, 22 Jun 2023 15:02:36 GMT https://community.qlik.com/t5/Qlik-Automate/Unable-to-connect-to-MS-SQL-Server/m-p/2086885#M2074 matthewharrison 2023-06-22T15:02:36Z https://community.qlik.com/t5/Qlik-Automate/Unable-to-connect-to-MS-SQL-Server/m-p/2087699#M2083 <P>Hi <SPAN style="background: var(--ck-color-mention-background); color: var(--ck-color-mention-text);"><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/183117">@matthewharrison</a></SPAN>!</P> <P>&nbsp;</P> <P>Yes, the error codes points indeed to either TLS 1,2, SQL Server configuration or credential issues. Since you have tried to fix these potential errors and still not been able to connect, I would suggest you open a case in our caseportal or via a live chat agent. You can do this here:&nbsp;</P> <P><A href="https://community.qlik.com/t5/crmsupport/page." target="_blank">https://community.qlik.com/t5/crmsupport/page.</A></P> <P>&nbsp;</P> <P>All the best,&nbsp;</P> <P>Tony</P> Mon, 26 Jun 2023 09:53:25 GMT https://community.qlik.com/t5/Qlik-Automate/Unable-to-connect-to-MS-SQL-Server/m-p/2087699#M2083 Tony7 2023-06-26T09:53:25Z