Tag Archives: System.Data.Entity.Core.EntityException: ‘The underlying provider failed on Open.’

[Solved] System.Data.Entity.Core.EntityException: ‘The underlying provider failed on Open.’

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.