SQL 用户被锁定时,代理处理程序升级失败
技术文章 ID:
KB93126
上次修改时间: 2022-03-18 20:34:45 Etc/GMT
环境
McAfee ePolicy Orchestrator (ePO) 5.10.x, 5.9.x
问题
代理处理程序升级失败。
AH5100-ahsetupdll_Systemname.log 文件记录以下错误:
I #03244 MFEFIPS Module Initialized.
I #03244 MFEFIPS MFEFIPS_Status() returned 1
I #03244 EPODAL Using SQL Authentication for [SGEEPODB01,1533].[ePO_SGEEPO01]
E #03244 EPODAL ePOData_Connection.cpp(657): COM Error 0x80040E4D, source=Microsoft SQL Server Native Client 11.0, desc=Login failed for user 'eposadmin'., msg=IDispatch error #3149
E #03244 EPODAL ePOData_Connection.cpp(373): COM Error 0x80040E4D, source=Microsoft SQL Server Native Client 11.0, desc=Login failed for user 'eposadmin'., msg=IDispatch error #3149
E #03244 EPODAL ePOData_Connection.cpp(398): Error 0x80040E4D returned from credentials callback. Database NOT available
E #03244 AHSETUP D:\BUILD_852722\BUILD\ePO\dev\src\server\include\epoData.inl(461): Database initialization: Failed (hr=0x80040E4D).
E #03244 AHSETUP ahsetup.cpp(116): Failed to connect to the database
The SQL Error.log文件 记录以下错误
Logon Error: 18456, Severity: 14, State: 78.
Logon Login failed for user 'eposadmin'.Reason: The account is currently locked out. The system administrator can unlock it. [CLIENT: 10.70.129.158]
spid17s CHECKDB for database 'ePO_SGEEPO01' finished without errors on 2020-07-12 12:05:33.137 (local time). This is an informational message only; no user action is required.
spid7s Recovery is complete. This is an informational message only. No user action is required.
spid7s Launched startup procedure 'LOG_SERVER_START'.
spid30s *** LOGGING SERVER STARTUP TIME ***
spid51 Configuration option 'Agent XPs' changed from 0 to 1. 运行 RECONFIGURE 语句进行安装。
..
Logon Error: 18456, Severity: 14, State: 78.
Logon Login failed for user 'eposadmin'.Reason: The account is currently locked out. The system administrator can unlock it. [CLIENT:10.70.129.158]
Logon Error: 18456, Severity: 14, State: 78.
..
Logon Login failed for user 'eposadmin'.Reason: The account is currently locked out. The system administrator can unlock it. [CLIENT:10.70.129.158]
..
Logon Error: 18456, Severity: 14, State: 8.
Logon Login failed for user 'eposadmin'. 原因: 密码与提供的登录密码不匹配。 [CLIENT:192.168.209.182]
原因
代理处理程序已与被锁定的用户连接到 SQL 数据库。
解决方案
在尝试升级代理处理程序之前,请执行以下一项操作:
- 解锁用户。
或
- 请尝试其他用户帐户。
重要说明:参阅KB75766,获得安装和使用 ePO 所需的 SQL 权限。
免责声明
本文内容源于英文。如果英文内容与其翻译内容之间存在差异,应始终以英文内容为准。本文部分内容是使用 Microsoft 的机器翻译技术进行翻译的。
|