“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:

IIS-AppPool-1-edit

IIS-AppPool-2-edit

 

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

IIS-AppPool-3-edit

 

Change it to LocalSystem:

IIS-AppPool-4-edit

 

And you’re done!

Advertisements
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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s