Run SQL Query - Connection String Error

With the upgrade to Workflow 5.45.1 I am getting an error with a server side workflow using the Run SQL Query. The error indicates it breaks after the User ID text and before the semi colon (where the ^ is in hte example).

"Error: 0: Unexpected Error: VertiGIS.Workflow.Runtime.Execution.Exceptions.ActivityExecutionException: [WF: Activity execution error] Failed to execute activity 16 with action gcx:wf:server::SqlQuery: Format of the initialization string does not conform to specification starting at index 51.",

Example Connection String:

Server xxx;Database=xxx;User Id=xxx^;Password='xxxx',TrustServerCertificate=True;

Ken Lyon

June 17, 2025 18:12

Hi Austin Hildreth. I'm not sure what change would have caused this. What version of Workflow were you on prior to 5.45.1?

Nico Burgerhart

June 17, 2025 21:10

Could it be related to this change?

https://support.vertigis.com/hc/en-us/articles/22789943303698-Encrypted-SQL-Server-Database-Connections

Austin Hildreth

June 23, 2025 15:33

Thank you for the responses. After upgrading to version5.45.1 the ‘TrustServerCertificate’ needed to be added to the connection string (we do not have a cert on our DB), however (my mistake) I added the extra parameter with a ‘,’ where a ‘;’ is needed (see above conn string). Simple resolution.

Thanks,

Austin

Run SQL Query - Connection String Error

Comments

Didn't find what you were looking for?