I am fetching data from the Azure SQL database. I am using Authentication=ActiveDirectoryPassword in my connection string. While doing so, my workflow is failing intermittently with the following error :
"Error opening connect string: Microsoft OLE DB Driver for SQL Server: Communication link failure\08S01 = 10054; Microsoft OLE DB Driver for SQL Server: TCP Provider: An existing connection was forcibly closed by the remote host.
\08S01 = 10054"
If I change the Authentication mode to SQL, my workflow runs without any errors.
I am not able to get the root cause for this.
As mentioned earlier, this is an intermittent issue. The workflow fails occasionally with the above error. Most of the time the workflow executes successfully.
Can anyone help me with this?
