The underlying provider failed on Open RRS feed

  • 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?

    Wednesday, November 28, 2012 9:53 AM

All replies

  • 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

    Thursday, November 29, 2012 5:46 AM