I have a strange problem using EF today
A simple EF query results in an error:
Exception:
System.Data.Entity.Core.EntityException: ‘The underlying provider failed on Open.’
Internal exception 1:
Transactionmanagercommunicationexception: communication with underlying transaction manager failed.
Internal exception 2:
Comexception: the transaction manager is not available. (exception from HResult: 0x8004d01b)
Solution 1:
The permissions given to the current database by the user NT authority\network service of the database.
After the permissions are configured, the query will not report errors.