jojacafe
1/17/2017 - 11:19 AM

iis entity framework the underlying provider failed on open

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/