CSNAPC-5973：在SQL Server上启用强制加密后、SCSQL备份失败

最后更新
另存为PDF

Views:: 1

Visibility:: Public

Votes:: 0

Category:: snapcenter

Specialty:: snapx

Last Updated:

问题描述

在SnapCenter 6.0 6.0.1和6.1中、如果在SQL Server中将"强制加密"设置为"是"、则适用于Microsoft SQL数据库的SnapCenter插件(SCSQL)备份将失败。
{}<installation_path>\Program Files\NetApp\SnapCenter\SnapCenter Plug-in for Microsoft SQL Server\log\SmSql_<id>.log{中出现完整错误：

DEBUG SmSql_116 PID=[3116] TID=[46] Connecting to SQL Server: [SQL_SERVER_PATH]
DEBUG SmSql_116 PID=[3116] TID=[46] Getting SQL server connection with user: domain\username
DEBUG SmSql_116 PID=[3116] TID=[46] Setting connection timeout in SQL server connection as 60
ERROR SmSql_116 PID=[3116] TID=[46] ConnectionFailureException: Failed to connect to server SQL_SERVER_PATH. A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.). The certificate chain was issued by an authority that is not trusted.

DEBUG SmSql_314 PID=[5552] TID=[87] Connecting to SQL Server: [sql1\SQLEXPRESS]
DEBUG SmSql_314 PID=[5552] TID=[87] Getting SQL server connection with user: demo\administrator
DEBUG SmSql_314 PID=[5552] TID=[87] Setting connection timeout in SQL server connection as 60
ERROR SmSql_314 PID=[5552] TID=[87] ConnectionFailureException: Failed to connect to server sql1\SQLEXPRESS. A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.). The target principal name is incorrect.
ERROR SmSql_314 PID=[5552] TID=[87] ErrorCode (10010), ErrorMessage (The user 'demo\administrator' does not have required permission to connect to the SQL instance 'sql1\SQLEXPRESS'. Error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.))
ERROR SmSql_314 PID=[5552] TID=[87] Failed to connect to SQL instance 'sql1\SQLEXPRESS'. Error: The user 'demo\administrator' does not have required permission to connect to the SQL instance 'sql1\SQLEXPRESS'. Error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.)