Entity Framework Login Failed Error
.net, entity-framework, wcf
Solution
It was stupid mistake!! There was no `NT AUTHORITY\NETWORK SERVICE` account in my SQL server logins. I have added it with required permissions. It now works with my configuration of app pool to `Network service` and `Integrated security=true` in connection string.
Problem
I have hosted my WCF application in IIS and set an app pool with 4.0 integrated. I configured the pool identity as network service. I have already checked other posts related to this issue but could not resolve it. I get the below exception ``` System.Data.Entity.Core.EntityException was unhandled by user code HResult=-2146233087 Message=The underlying provider failed on Open. Source=EntityFramework ``` I tried modifying app pool to localsystem from network service, it works fine. Any guess why it takes my system name as login in the earlier case?