問題:開啟OGWeb與OGServer發生錯誤:[使用者 '(Username)' 的登入失敗。]

徵狀

'/OGWeb' 應用程式中發生伺服器錯誤。
使用者 '(Username)' 的登入失敗。
描述:在執行目前 Web 要求的過程中發生未處理的例外狀況。請檢閱堆疊追蹤以取得錯誤的詳細資訊,以及在程式碼中產生的位置。
例外狀況詳細資訊:System.Data.SqlClient.SqlException: 使用者 '(Username)' 的登入失敗。
原始程式錯誤:
在執行目前 Web 要求期間,產生未處理的例外狀況。如需有關例外狀況來源與位置的資訊,可以使用下列的例外狀況堆疊追蹤取得。

堆疊追蹤:

[SqlException (0x80131904): 使用者 '(Username)' 的登入失敗。]

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6564850

System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling) +821 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +332 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +38 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +699 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +89 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +426 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +78 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +191 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +154 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +21 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +90 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +443 System.Data.SqlClient.SqlConnection.Open() +96 TQuark.Lib.Data.AutoDbConnection..ctor(IDbConnection connection) +88 TQuark.Lib.Data.SQL.SqlHelp.GetDataTable(SqlCommand command, MissingSchemaAction missingAction) +150 TQuark.Lib.Data.SQL.SqlHelp.GetDataTable(SqlCommand command) +47 TQuark.Lib.Data.SQL.SqlOperation.TQuark.Lib.Data.IDatabaseOperation.GetDataTable(IDbCommand sqlCommand) +84 TQuark.Lib.Data.DBHelp.GetDataTable(IDbCommand command) +75 TQuark.Lib.Data.DBHelp.GetDataTable(IDbConnection connection, String sqlCommand) +109 TQuark.Lib.Data.Logging.LogEntryCreateInfoDBLoader.LoadFromTable(IDbConnection connection, String tableName) +90 TQuark.OG.Web.OGWeb.Global._Application_Start(Object sender, EventArgs e) +205 TQuark.Lib.Web.TQuarkApplication.Application_Start(Object sender, EventArgs e) +869

[HttpException (0x80004005): 使用者 '(Username)' 的登入失敗。]

System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +10104513 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +118 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +173 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +336 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +296

[HttpException (0x80004005): 使用者 '(Username)' 的登入失敗。]

System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +10085804 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +95 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +254

版本資訊: Microsoft .NET Framework 版本:4.0.30319; ASP.NET 版本:4.7.2110.0

原因及解決方案

可能原因有:

  1. 帳號或密碼被修改
  2. DB登入帳號強制執行密碼逾期
  3. 驗證模式應選擇SQL Server 及 Windows驗證模式

最終審定

最後檢閱日期:2022/11/10
適用門將版本號:1.0含以上
問題編號:2015091515