article Qlik Replicate: cannot add Azure SQL DB target endpoint with error Failed to get syntax in Official Support Articles

article Qlik Replicate: cannot add Azure SQL DB target endpoint with error Failed to get syntax in Official Support Articles https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-cannot-add-Azure-SQL-DB-target-endpoint-with/ta-p/2122079 <P>Creating and adding a new target endpoint to Azure SQL DB and testing the connection fails with:</P> <P class="lia-indent-padding-left-30px"><FONT face="courier new,courier">SYS-E-HTTPFAIL, Failed to load dynamic endpoint properties.</FONT><BR /><FONT face="courier new,courier">SYS,GENERAL_EXCEPTION,Failed to load dynamic endpoint properties,Failed to get 'SQLServer_New' syntax</FONT></P> <H3><FONT color="#339966"><STRONG>Resolution</STRONG></FONT></H3> <P>Review the active <STRONG>Internal Parameters</STRONG> set in the endpoint. </P> <OL> <LI>Go to the  <STRONG>Endpoint</STRONG><SPAN> </SPAN>connection</LI> <LI>Switch to the<SPAN> </SPAN><STRONG>Advanced </STRONG>tab</LI> <LI>Click<SPAN> </SPAN><STRONG>Internal Parameters</STRONG></LI> <LI>Review the set parameters for a <STRONG>syntax </STRONG>parameter set to a specific value (in our example: <FONT face="courier new,courier">SQLServer_New</FONT>).</LI> <LI><STRONG>Remove</STRONG> the <STRONG>Internal Parameter</STRONG>.<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="syntax added.png" style="width: 716px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/117166i92426904D00EA86C/image-size/large?v=v2&px=999" role="button" title="syntax added.png" alt="syntax added.png" /></span></LI> </OL> <P> </P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <P class="lia-indent-padding-left-30px"><LI-PRODUCT title="Qlik Replicate" id="qlikReplicate"></LI-PRODUCT> </P> <P> </P> Wed, 27 Sep 2023 08:27:14 GMT Dineshan 2023-09-27T08:27:14Z Qlik Replicate: cannot add Azure SQL DB target endpoint with error Failed to get syntax https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-cannot-add-Azure-SQL-DB-target-endpoint-with/ta-p/2122079 <P>Creating and adding a new target endpoint to Azure SQL DB and testing the connection fails with:</P> <P class="lia-indent-padding-left-30px"><FONT face="courier new,courier">SYS-E-HTTPFAIL, Failed to load dynamic endpoint properties.</FONT><BR /><FONT face="courier new,courier">SYS,GENERAL_EXCEPTION,Failed to load dynamic endpoint properties,Failed to get 'SQLServer_New' syntax</FONT></P> <H3><FONT color="#339966"><STRONG>Resolution</STRONG></FONT></H3> <P>Review the active <STRONG>Internal Parameters</STRONG> set in the endpoint. </P> <OL> <LI>Go to the  <STRONG>Endpoint</STRONG><SPAN> </SPAN>connection</LI> <LI>Switch to the<SPAN> </SPAN><STRONG>Advanced </STRONG>tab</LI> <LI>Click<SPAN> </SPAN><STRONG>Internal Parameters</STRONG></LI> <LI>Review the set parameters for a <STRONG>syntax </STRONG>parameter set to a specific value (in our example: <FONT face="courier new,courier">SQLServer_New</FONT>).</LI> <LI><STRONG>Remove</STRONG> the <STRONG>Internal Parameter</STRONG>.<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="syntax added.png" style="width: 716px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/117166i92426904D00EA86C/image-size/large?v=v2&px=999" role="button" title="syntax added.png" alt="syntax added.png" /></span></LI> </OL> <P> </P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <P class="lia-indent-padding-left-30px"><LI-PRODUCT title="Qlik Replicate" id="qlikReplicate"></LI-PRODUCT> </P> <P> </P> Wed, 27 Sep 2023 08:27:14 GMT https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-cannot-add-Azure-SQL-DB-target-endpoint-with/ta-p/2122079 Dineshan 2023-09-27T08:27:14Z