Hello
I recently added a new agent for an SQL connector to our on prem group in development. Previously, there was only an agent for our on prem network file share, which was working correctly. I downloaded, installed and connected the windows agent on our SQL server and was able to get the SQL connector in my recipe working. However, since then, the original on prem agent for the network fileshare will not remain connected. Every time I try to test the recipe, I get an error stating "Your connection is no longer valid. Please connect to On-prem files.". I then re connect the on prem files, try and re test the recipe and get the same error. Additionally, Workato creates a new connection every time eg:"my second on prem files account/my third on prem files account" etc. What am I missing here? The only difference I see is that the agent versions are different, the new one is using version 26.0 and the original fileshare agent is 24.3. Both agents show as active.
The SQL agent is using SQL Server authentication and on a completely different server than the original fileshare agent. .
