Question:
We have installed a new instance of identify and we are getting the following exception when we try to add a new connection:
The underlying provider failed on Open. | |
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) at System.Data.EntityClient.EntityConnection.Open() at System.Data.Objects.ObjectContext.EnsureConnection() at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() at Safewhere.IdentityProvider.SqlCache.SqlIdentityProviderCacheManager.YMyAyLcFQ() at Safewhere.IdentityProvider.SqlCache.SqlIdentityProviderCacheManager.InvalidateProtocolConnectionCache() at Safewhere.IdentityProvider.Cache.CachingProtocolConnectionRepository.Insert(ProtocolConnection item) at Safewhere.IdentityProvid |
Any idea what we have done wrong?
Answer:
We believe that lack of permission caused this issue, e.g. http://th2tran.blogspot.com/2009/06/underlying-provider-failed-on-open.html.
Please check if the exception have any inner exception that can be found in Windows event log? Or does Windows also log some other useful events?