"The underlying supplier failed on Open," says Entity Framework.

asp.net entity-framework

Question

I see the following problem while attempting to enter a record: The underlying provider failed on Open. Only IIS experiences this problem; VWD 2008's webserver does not. I get the following application error in EventViewer: failed to start the procedure for the user instance, which prevented SQL Server from generating a user instance. The link will be cut off. [CLIENT:]

<add name="ASPNETDBEntities"
     connectionString="
         metadata=res://*/Models.FriendList.csdl|res://*/Models.FriendList.ssdl|res://*/Models.FriendList.msl;
         provider=System.Data.SqlClient;
         provider connection string=&quot;
         Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;
         Integrated Security=True;
         Connect Timeout=30;
         User Instance=True;
         MultipleActiveResultSets=True&quot;"
     providerName="System.Data.EntityClient" />

Instead of utilizing an external database, I am using the aspnetdb.mdf file. I've looked everywhere for this, but to no avail.

With the VWD webserver, everything is in order.

1
17
1/4/2012 6:07:29 PM

Popular Answer

In order for your web server to access the aspnetdb database, you need establish a sql account. At the moment, it makes use of integrated authentication (tries to logon with the identity the web server is using to run the application).

Integrated auth is used in the example below. However, I would use SQL auth.

http://msdn.microsoft.com/en-us/library/ff649314.aspx

10
5/16/2010 8:10:32 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow