SCSQL 备份失败并出现错误:无法连接到服务器服务器名。用户用户名登录失败
状态信息
适用于
- SnapCenter ( SC ) 4.1 及更高版本
- SnapCenter 插件(用于 SQL )( SCSQL ) 4.1 及更高版本
问题
SCSQL 中的备份失败
- 无法连接 SQL Server
- 登录失败
- SMSQL 日志中的错误消息:
DEBUG SmSql_22499 PID=[51744] TID=[9] GetSqlAccess Enter DEBUG SmSql_22499 PID=[51744] TID=[9] Connecting to SQL Server: <ServerName> ERROR SmSql_22499 PID=[51744] TID=[9] ConnectionFailureException: Failed to connect to server <ServerName>. Login failed for user <UserName> ERROR SmSql_22499 PID=[51744] TID=[9] ErrorCode (-1), ErrorMessage (The SQL instance <InstanceName> is either stopped or the user <UserName> does not have required permission. Error: Failed to connect to server <ServerName>) DEBUG SmSql_22499 PID=[51744] TID=[9] Retrying Sql connection with user: <UserName> DEBUG SmSql_22499 PID=[51744] TID=[9] Connecting to SQL Server: <ServerName> ERROR SmSql_22499 PID=[51744] TID=[9] ConnectionFailureException: The user name or password is incorrect. ERROR SmSql_22499 PID=[51744] TID=[9] ErrorCode (-1), ErrorMessage (The SQL instance <InstanceName> is either stopped or the user <UserName> does not have required permission. Error: The user name or password is incorrect.
SQL 错误日志中的错误消息:Logon Error: 18456, Severity: 14, State: 11. Logon Login failed for user <UserName>. Reason: Token-based server access validation failed with an infrastructure error.