用户代码未处理System.Data.EntityException HResult = -2146233087消息=基础提供程序在打开时失败。 Source = System.Data.Entity StackTrace：at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf [英] System.Data.EntityException was unhandled by user code HResult=-2146233087 Message=The underlying provider failed on Open. Source=System.Data.Entity StackTrace: at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf

问题描述

您好：

我正在尝试运行由其他开发人员开发的应用程序。我已经摆脱了所有错误但是当我尝试运行应用程序时，我收到此错误，当然，无法进行身份验证和失败：

 System.Data.EntityException未被用户代码处理
 HResult = -2146233087 
消息=基础提供程序在打开时失败。 
 Source = System.Data.Entity 
 StackTrace：
 at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf（Boolean openCondition，DbConnection storeConnectionToOpen，DbConnection originalConnection，String exceptionCode，String attemptsOperation，Boolean& closeStoreConnectionOnFailure ）System.Data.Object.Object.EpenResults的System.Data.EntityClient.EntityConnection.Open（）
 at System.Data.Objects.ObjectContext.EnsureConnection（）
 at System.Data.Objects.ObjectQuery`1.GetResults Nullable`1 forMergeOption）
 at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable< T> .GetEnumerator（）
 at System.Data.Entity.Internal.Linq.InternalQuery `1.GetEnumerator（）
在System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable< TResult> .GetEnumerator（）
 at System.Linq.Buffer`1。 System（Linknnumerator>） xt（）
 at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext（）
 at System.Collections.Generic.List`1..ctor（IEnumerable`1 collection）
 at System .Linq.Enumerable.ToList [TSource]（IEnumerable`1源）
。在Regenstrief.LOINCSubmission.Web.Controllers.BaseController.LOINCDevelopersDropDownList（字符串选择在c）中：\dev\LOINC\Submission\Dev \Regenstrief.LOINCSubmission.Web\Controllers\BaseController.cs：在Regenstrief.LOINCSubmission.Web.Controllers.SubmissionController.List（c）中线884 
：\dev\LOINC\Submission\ Dev\Regenstrief.LOINCSubmission.Web\Controllers\SubmissionController.cs：线573 
。在lambda_method（封闭，ControllerBase，对象[]）
。在System.Web.Mvc.ActionMethodDispatcher.Execute（ControllerBase controller，Object []参数）
 at System.Web.Mvc.ReflectedActionDescriptor.Execute（ControllerContext controllerCon）文本，IDictionary`2参数）
。在System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod（ControllerContext controllerContext，ActionDescriptor actionDescriptor，IDictionary`2参数）LT 
。在System.Web.Mvc.Async.AsyncControllerActionInvoker&; > c__DisplayClass42。< BeginInvokeSynchronousActionMethod> b__41（）
 at System.Web.Mvc.Async.AsyncResultWrapper。<> c__DisplayClass8`1。< BeginSynchronous> b__7（IAsyncResult _）
 at System。 Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End（）
 at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod（IAsyncResult asyncResult）
 at System.Web.Mvc.Async.AsyncControllerActionInvoker。 <> c__DisplayClass37。<> c__DisplayClass39。< BeginInvokeActionMethodWithFilters> b__33（）
在System.Web.Mvc.Async.AsyncControllerActionInvoker。<> c__DisplayClass4f。< InvokeActionMethodFilterAssechronously> b__49（）
 InnerException： System.Data.SqlClient.SqlException 
 HResult = -2146232060 
消息=用户'regi_loinc_submission'登录失败。 
 Source = .Net SqlClient Data Provider 
 ErrorCode = -2146232060 
 Class = 14 
 LineNumber = 65536 
 Number = 18456 
 Procedure ="" 
 Server = IN-REGI-045479 \SANDBOX 
 State = 1 
 StackTrace：
 at System.Data.SqlClient.SqlInternalConnection.OnError（SqlException exception，Boolean breakConnection，Action` 1 wrapCloseInAction）
 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning（TdsParserStateObject stateObj，Boolean callerHasConnectionLock，Boolean asyncClose）
 at System.Data.SqlClient.TdsParser.TryRun（RunBehavior runBehavior，SqlCommand cmdHandler，SqlDataReader dataStream） ，BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObject stateObj，Boolean& dataReady）
 at System.Data.SqlClient.TdsParser.Run（RunBehavior runBehavior，SqlCommand cmdHandler，SqlDataReader dataStream，BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObject stateObj）
 at System.Data。 SqlClient.SqlInternalConnectionTds.CompleteLogin（Boolean enlistOK）
 at System.Data.SqlClient.SqlInternalConnectionTds.At temptOneLogin（ServerInfo serverInfo，String newPassword，SecureString newSecurePassword，Boolean ignoreSniOpenTimeout，TimeoutTimer timeout，Boolean withFailover）
 at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover（ServerInfo serverInfo，String newPassword，SecureString newSecurePassword，Boolean redirectedUserInstance，SqlConnectionString connectionOptions， SqlCredential凭证，TimeoutTimer超时）
在System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist（TimeoutTimer超时，SqlConnectionString connectionOptions，SqlCredential凭证，String newPassword，SecureString newSecurePassword，Boolean redirectedUserInstance）
在System.Data.SqlClient。 SqlInternalConnectionTds..ctor（DbConnectionPoolIdentity标识，SqlConnectionString connectionOptions，SqlCredential凭证，Object providerInfo，String newPassword，SecureString newSecurePassword，Boolean redirectedUserInstance，SqlConnectionString userConn ectionOptions，SessionData reconnectSessionData）
 at System.Data.SqlClient.SqlConnectionFactory.CreateConnection（DbConnectionOptions options，DbConnectionPoolKey poolKey，Object poolGroupProviderInfo，DbConnectionPool pool，DbConnection owningConnection，DbConnectionOptions userOptions）
 at System.Data.ProviderBase.DbConnectionFactory .CreatePooledConnection（DbConnectionPool池，DbConnection owningObject，DbConnectionOptions选项，DbConnectionPoolKey poolKey，DbConnectionOptions userOptions）
 at System.Data.ProviderBase.DbConnectionPool.CreateObject（DbConnection owningObject，DbConnectionOptions userOptions，DbConnectionInternal oldConnection）
 at System.Data .ProviderBase.DbConnectionPool.UserCreateRequest（的DbConnection owningObject，DbConnectionOptions USEROPTIONS，DbConnectionInternal oldConnection）
。在System.Data.ProviderBase.DbConnectionPool.TryGetConnection（的DbConnection owningObject，UInt32的WAITFOR MultipleObjectsTimeout，Boolean allowCreate，Boolean onlyOneCheckConnection，DbConnectionOptions userOptions，DbConnectionInternal&连接）
在System.Data.ProviderBase.DbConnectionPool.TryGetConnection（DbConnection owningObject，TaskCompletionSource`1 retry，DbConnectionOptions userOptions，DbConnectionInternal& connection）
 at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection（DbConnection owningConnection， TaskCompletionSource`1 retry，DbConnectionOptions userOptions，DbConnectionInternal oldConnection，DbConnectionInternal& connection）
 at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal（DbConnection outerConnection，DbConnectionFactory connectionFactory，TaskCompletionSource`1 retry，DbConnectionOptions userOptions）
 at System .Data.ProviderBase.DbConnectionClosed.TryOpenConnection（DbConnection outerConnection，DbConnectionFactory connectionFactory，TaskCompletionSource`1 retry，DbConnectionOptions userOptions）
 at System.Data.SqlClient.SqlConnection.TryOpenInner（TaskCompletionSource`1 r etry）
在System.Data.SqlClient.SqlConnection.TryOpen（TaskCompletionSource`1重试）在System.Data.SqlClient.SqlConnection.Open 
（）
在System.Data.EntityClient.EntityConnection .OpenStoreConnectionIf（Boolean openCondition，DbConnection storeConnectionToOpen，DbConnection originalConnection，String exceptionCode，String attemptsOperation，Boolean& closeStoreConnectionOnFailure）
 InnerException：
 

我有一个在我的机器上本地运行的数据库，我已经检查了我的连接字符串到数据库。它们都引用了适当的本地数据库。我也去了SQL服务器并删除了这个应用程序的用户并创建了一个新用户，在
的情况下用户已经被损坏了。

如果有人有任何想法，我一定会很感激反馈。谢谢Michele

解决方案

Hi Michele，

由于您的问题与实体框架，asp.net中的配置和部署更相关。我建议你在以下论坛上发布你的问题以获得专业的答案：

https://forums.asp.net/26.aspx/1?Configuration+and+Dloyment

我'我们联系了支持工程师，他们会帮助你。

感谢您的理解

祝你有愉快的一天:)

祝你好运，

陈伟伟

Hello:

I am trying to run an application developed by another developer who has since left. I have gotten rid of all errors but when I try to run the application, I receive this error and of course, cannot authenticate and fail:

System.Data.EntityException was unhandled by user code
  HResult=-2146233087
  Message=The underlying provider failed on Open.
  Source=System.Data.Entity
  StackTrace:
       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.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
       at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
       at System.Data.Entity.Internal.Linq.InternalQuery`1.GetEnumerator()
       at System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator()
       at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
       at System.Linq.OrderedEnumerable`1.<GetEnumerator>d__0.MoveNext()
       at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at Regenstrief.LOINCSubmission.Web.Controllers.BaseController.LOINCDevelopersDropDownList(String selected) in c:\dev\LOINC\Submission\Dev\Regenstrief.LOINCSubmission.Web\Controllers\BaseController.cs:line 884
       at Regenstrief.LOINCSubmission.Web.Controllers.SubmissionController.List() in c:\dev\LOINC\Submission\Dev\Regenstrief.LOINCSubmission.Web\Controllers\SubmissionController.cs:line 573
       at lambda_method(Closure , ControllerBase , Object[] )
       at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
       at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41()
       at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)
       at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass37.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33()
       at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49()
  InnerException: System.Data.SqlClient.SqlException
       HResult=-2146232060
       Message=Login failed for user 'regi_loinc_submission'.
       Source=.Net SqlClient Data Provider
       ErrorCode=-2146232060
       Class=14
       LineNumber=65536
       Number=18456
       Procedure=""
       Server=IN-REGI-045479\SANDBOX
       State=1
       StackTrace:
            at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
            at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
            at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
            at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
            at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
            at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
            at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
            at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
            at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
            at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
            at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
            at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
            at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
            at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
            at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
            at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
            at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
            at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
            at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
            at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
            at System.Data.SqlClient.SqlConnection.Open()
            at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
       InnerException: 

I have a database that runs locally on my machine and I have checked my connection strings to the database. They all reference the proper local database. I have also gone out to SQL server and deleted the user for this application and made a new one, in case that user had been corrupted somehow.

If anyone has any ideas, I sure would appreciate feedback. Thank you, Michele

解决方案

Hi Michele,

As your issue is more related to Entity Framework, the configuration and deployment in asp.net. I suggest you post your issue in following forum to get a professional answer:

https://forums.asp.net/26.aspx/1?Configuration+and+Deployment

I've contacted the support engineers and they will help you out there.

Thanks for your understandings

Have a nice day:)

Best regards,

Fletch

这篇关于用户代码未处理System.Data.EntityException HResult = -2146233087消息=基础提供程序在打开时失败。 Source = System.Data.Entity StackTrace：at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！