System.Data.SqlClient.SqlException (0x80131904): Login faile

Question

Microsoft .NET Framework Version:4.0.30319;ASP。. NET版本:4.8.4494.0供参考。所以我目前有一个测试网站，不允许我访问它的数据库。每次您尝试登录时，它都会弹出以下错误。从我的角度来看，我试着在网上寻找一些其他的建议，比如网络。配置可能被打破了，我已经检查过了，以前的工作版本没有变化报告。一些小的更新已经回滚，在系统上无效。所有IIS服务都在运行，并且可以确认与同一服务器上的另一个站点一起工作。

一些进一步的信息该网站目前正在运行一个集成的连接，我已经尝试做一个显式的连接以及相同的结果。所有SQL server服务都已启动并运行。从服务器事件查看器中，我得到的最好结果是

Reason: Could not find a login matching the name provided.

我还检查了防火墙规则，以确保它们仍然允许连接，它们通过所需的端口。所以坦白地说，我有点不知所措，不知道下一步该做什么，或者我是否错过了一些非常明显的东西

[SqlException (0x80131904): Login failed for user 'WORKGROUPx'.]
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +1341
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +159
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +382
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +307
System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +198
System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +422
System.Data.SqlClient.SqlConnection.Open() +199
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +86
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +333
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1141
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +166
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +178
x.Models.AccountMembershipService.ValidateUser(String userName, String password) in D:x RepoDevxModelsUsersAccountModels.cs:212
x.Controllers.AccountController.LogOn(LogOnModel model, String returnUrl) in D:x RepoDevxControllersUsersAccountController.cs:225
lambda_method(Closure , ControllerBase , Object[] ) +191
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +35
System.Web.Mvc.Async.<>c.<BeginInvokeSynchronousActionMethod>b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +39
System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +77
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +42
System.Web.Mvc.Async.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0() +80
System.Web.Mvc.Async.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2() +396
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +42
System.Web.Mvc.Async.<>c__DisplayClass3_6.<BeginInvokeAction>b__4() +50
System.Web.Mvc.Async.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult) +188
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +38
System.Web.Mvc.<>c.<BeginExecuteCore>b__152_1(IAsyncResult asyncResult, ExecuteCoreState innerState) +29
System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +52
System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +39
System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +38
System.Web.Mvc.<>c.<BeginProcessRequest>b__20_1(IAsyncResult asyncResult, ProcessRequestState innerState) +43
System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +38
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +651
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +134

尝试重新启动服务

试图修改web.config

已检查的防火墙规则

回滚包更新

到达站点时，您需要使用数据库上的凭据登录。这是不允许的。在发布的构建之间没有进行重大更改，并且当通过IIS express运行站点的本地主机版本时，站点可以使用与测试服务器上相同的集成约束访问数据库。我看过的其他类似问题在测试

时没有解决问题。

Answer 1

找到解决方案

应用程序池数据库信息正在覆盖web。配置连接数据，这是以前没有发生过的事情，但为了解决它，应用程序池信息只是被带入一行，以免得到任何奇怪的冲突，在那里信息被完全搞混了。