The certificate chain was issued by an authority that is not trusted

Hello, Since I updated the SQLBackupAndFTP to latest version it’s not running any job and giving the following error, please help.

Failed to backup “letsmove” database with “Full” backup type: Could not connect to database server. > 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

Hello ASHISH_trivedi,

To resolve the issue, please navigate to the advanced SQL Server connection settings and enable the “Trust Server Certificate” option.

SQLBackupAndFTP

If you have any other questions, please let us know.

Thank you for using SQLBackupAndFTP, and we apologize for the inconvenience.

We are using Azure SQL Server and it has no Advance option while connecting to server.
45d3a043-ed78-41a4-9529-716805f89514

Hello,

Thank you for your email.

Please try to connect using a Microsoft SQL Server (remote) connection and input your credentials. Using the Microsoft SQL Server (remote) option enables the “Trust Server Certificate” feature.

If you have any other questions, please let us know.

Thank you for using SQLBackupAndFTP, and we apologize for the inconvenience.