When attempting to install Orchestrator 2021.10.x for the first time on our machine, or we are upgrading to 2021.10.x from an older version. It always fails with the same error message: System.Exception: Error:-1, Message:An error occurred while retrieving latest migrations. 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 target principal name is incorrect.)After this is shown, the installation is rolled back.
Use the FQDN for the DB when installing/upgrading the Orchestrator.