I am facing this error for days and I still can't find a solution.
Here is the error:
I have multiple services that connect on the same sql server instance and obviously on the same database.
Our IT Managers did this for balance computing, or at least this is what they said.
This is part of the stack trace, hoping could help:
Message: <ii>This SqlTransaction has completed; it is no longer usable.</ii>
When the error occours, the "victim" nav service stop working and all the connected users can't do anything. They must exit and try to login again after few minutes.
The other services still working fine. This happen randomly, I didn't find any event that raise the error.
I'm still having this issue.
I can add that I'm using NAV 2018 with sql 2016 standard.
Did you solve this issue? We have unfortunately the same problem in NAV2018. We have more services connected to the same SQL and database too, for balancing reasons.