Error message:
[error]Couldn't connect to the database specified by the Target parameter: 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.)
Recommended solutions:
Azure DevOps:
1 - Fix the certificate trust issue on the Azure DevOps agent (if using RDS https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html)
2 - Use a Powershell task instead and use the SCA PS cmdlets directly: you will be able to add Trust Server Certificate=True
to the connection strings this way)
Octopus Deploy
1 - Fix your certificate validation issues
2 - Edit the SQL Change Automation template so that it adds TrustServerCertificate=True