RSS

WCF Exception in IIS Only (“The underlying provider failed on Open”) – Access to Entity Framework

07 Mar

What if you try to run your WCF Service in IIS and get the following error although you have already done this post?

The underlying provider failed on Open.

For my case, it only happens when deploying to IIS 7.5. Everything runs perfectly fine in local (under Visual Studio 2008). This is .Net framework 3.5. The WCF Service is accessing Entity Framework on back end.

Well, check on the firewall rules. The following ports are being dropped:

MSSQL Monitor (Revolver) – Port 1434 (UDP)
Microsoft-DS Active Directory – Port 445 (TCP)

These ports need to be in white-list for Entity Framework communication between source (web server) and destination (database server).

About these ads
 
1 Comment

Posted by on March 7, 2011 in Debug

 

Tags: , , , ,

One response to “WCF Exception in IIS Only (“The underlying provider failed on Open”) – Access to Entity Framework

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

 
Follow

Get every new post delivered to your Inbox.

Join 38 other followers

%d bloggers like this: