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.
As you are using the AttachDbFilename with your connection string, if your hosting environment does not have SQL Express installed, you cannot use this feature. Verify that you have SQL Express (any version) installed on your host. Otherwise, you will
need to add the database to an actual SQL Server instance on your host.
If your host has SQL Express installed, then you may need to verify the Data Source and determine if Integrated Security is allowed within the hosting environment.
Christopher Reed, MCT, MCPD, MCTS, Microsoft Specialist, MTA
"The oxen are slow, but the earth is patient."
It run fine locally but after hosting it i got the following error
Hi,
There must be something wrong with your connection string——I think you can just try to modify that by trying to connect to the Server Explorer first in "View"=>"Server Explorer" and create the connection to the remote SQL Server and copy the connection string
from the panel.
steveitgloba...
Member
7 Points
9 Posts
The underlying provider failed on Open
Nov 28, 2012 09:30 AM|LINK
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?
</div>Careed
All-Star
18764 Points
3637 Posts
Re: The underlying provider failed on Open
Nov 28, 2012 12:40 PM|LINK
As you are using the AttachDbFilename with your connection string, if your hosting environment does not have SQL Express installed, you cannot use this feature. Verify that you have SQL Express (any version) installed on your host. Otherwise, you will need to add the database to an actual SQL Server instance on your host.
If your host has SQL Express installed, then you may need to verify the Data Source and determine if Integrated Security is allowed within the hosting environment.
"The oxen are slow, but the earth is patient."
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: The underlying provider failed on Open
Nov 29, 2012 12:30 AM|LINK
Hi,
There must be something wrong with your connection string——I think you can just try to modify that by trying to connect to the Server Explorer first in "View"=>"Server Explorer" and create the connection to the remote SQL Server and copy the connection string from the panel.
Reguards!