The underlying provider failed on Open

Question

I created my EDM and generated a database in my SQL Server 2008 Express edition, which is installed locally. It run fine locally but after hosting it i got the following error

The underlying provider failed on Open.&Err=Exception of type 'System.Web.HttpUnhandledException' was thrown.

My connection string are

add name="MobileShawarmaEntities" connectionString="metadata=res://*/Data_Access.MobileShawarma.csdl|res://*/Data_Access.MobileShawarma.ssdl|res://*/Data_Access.MobileShawarma.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MobileShawarma.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />

Please do any one have answer to me?

Answer 1

Hi,

What do you mean by hosting it?   If you are deploying it in other servers, you need to make sure SQL Server Express is installed correctly in that server.

Good day!

---

Michael Sun [MSFT]
MSDN Community Support | Feedback to us