“The underlying provider failed on Open”

If you get the above exception message from accessing your database via the Entity Framework after you’ve deployed your web application or service to IIS (7.5), it is probably because of the DefaultAppPool Identity. Changing it to LocalSystem solved this problem for me.

Here’s how you do it:

Go to the ‘Advanced Settings’ for DefaultAppPool:




In the Advanced Settings dialog, look for Identity under Process Model:



Change it to LocalSystem:



And you’re done!

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s