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.