iis entity framework the underlying provider failed on open
We used this method for IIS 6:
1. Add User to IIS_WPG group: Go to Computer Management on the box hosting the site, Local Users and Groups > Groups, right-click IIS_WPG > Add to Group, then add the windows account, Apply, OK.
2. Then allow account to run as service: Admin Tools > Local Security Policy > Local Policies > User Rights Assignment > Log on as a service Properties, Add user, Apply, OK
3. Set App Pool Identity: IIS > App Pool Properties > Identity tab, set as configurable and input user, Apply, OK.
4. Then reboot box.
https://blogs.msdn.microsoft.com/friis/2010/10/08/steps-for-setting-up-a-custom-identity-of-an-iis-6-application-pool/