locked
The underlying provider failed on Open:System.Data.EntityException problem? RRS feed

  • Question

  • I try to deploy a data service to a IIS 6.0 Whose OS is window server 2003 and .net framework 3.5 sp1 is installed ,but when I try to query data from this dataservice it give me the following error: but  when I point my web app to another  dataservice which host in window server 2008 ,it work fine, I hope that one expert can give  me some clue for how to fix this dataservice deployment  or  iis configration problem.

    The underlying provider failed on Open:System.Data.EntityException,at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
\n   at System.Data.EntityClient.EntityConnection.Open()
\n   at System.Data.Objects.ObjectContext.EnsureConnection()
\n   at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
\n   at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
\n   at System.Data.Objects.ObjectQuery`1.GetEnumeratorInternal()
\n   at System.Data.Objects.ObjectQuery.System.Collections.IEnumerable.GetEnumerator()
\n   at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)
\n   at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService)
\n   at System.Data.Services.DataService`1.HandleNonBatchRequest(RequestDescription description)
\n   at System.Data.Services.DataService`1.HandleRequest()

    Thanks.
    Monday, September 21, 2009 3:20 PM

Answers

  • Hi Jake,
      Did you also get an error message stating why the provider couldn't connect?
      Normally , this is an error message along the lines of "User is not associated with a secure connection"
      Or something along those lines.
     Also , in the connection string , are you hard-coding a specific SQL Server user name and password or are you passing in the logged in user's credentials  using "Use Integrated Security = true"


     
    Phani Raj Astoria http://blogs.msdn.com/PhaniRaj
    • Marked as answer by Jake Wardley Tuesday, September 22, 2009 1:32 PM
    Monday, September 21, 2009 4:17 PM
    Moderator