CSNAPC-5973: SCSQL backup fails with Force Encryption enabled on SQL Server
- Views:
- 30
- Visibility:
- Public
- Votes:
- 0
- Category:
- snapcenter
- Specialty:
- snapx
- Last Updated:
- 4/16/2025, 1:34:44 PM
Issue
- In SnapCenter 6.0, 6.0.1 and 6.1, SnapCenter Plug-in for Microsoft SQL Database (SCSQL) backup fails if Force Encryption is set to Yes in SQL Server.
- Full error in
{}<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.)