Failed to upgrade Orchestrator due to SQL database authentication error in AWS.
Issue Description
Failed to upgrade Orchestrator due to SQL database authentication error in AWS. The Orchestrator SQL Server is on AWS RDS and running the latest engine version 15.00.4236.7.v1, self signed certificate is used on the Orchestrator EC2 instance.
Error Message
System.Exception: Migration failed: 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.)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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.)
Resolution
- During the upgrade, disable the “rds.force_ssl” parameter in the RDS database parameter group - it turns off forcing connection to DB to use SSL
- Enable it after the upgrade.
Details of the parameter can be found at the reference link Using SSL with a Microsoft SQL Server DB instance.