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()
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 byJake WardleyTuesday, September 22, 2009 1:32 PM