This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 19%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
In my workflow when i am adding activity SQL Server (in App) and add connection to my database there is an error message when trying to save the updated workflow:
The error message is cryptic and I cant find this mismatch from the schema in the code-view that is generated.
The odd -thing is that I can view tables in my database before saving the workflow, which indicates that I am connected to database. But logic app wont let me save the sql connection, ergo error-message. How do I fix this?
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
The workflow is very simple (test-flow), just to see that I get established connection. So there is no specification on what the worflow expect.
I have also re-created the sql-server connection from scatch.
I also created several workflow to test this.
Unfortunatly the detailed error logs didnt provide any additional information, either.
Can inform that we have now resolved this issue.
Issue was in a connection config from previous code that was deployed from pipeline.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 50%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHC%3C/text%3E%3C/svg%3E)
Are you connecting to SQL Server in Azure VM / (on prem sql) ? Which auth method are you using? I can get sql auth to work but none of the others like service principal entra id or managed identity etc.