How to troubleshoot DB migration failed issue, while installation of Orchestrator or Identity as PaaS?
This error generally occurs if there is an issue with DB connectivity or if the DB is not created as per the Prerequisites For Installation of SQL Server .
Error Message :
Resolution : Ensure the below data
- Connection string is valid
- DB type is correct. If it is Azure SQL PaaS then the type should be SQLAzure.
- Connection string name is correct. For Orchestrator it should be Default and for Identity Server, it should be DefaultConnection.
- IP of the machine where script is running is whitelisted in the SQL firewall. Read more Use Azure Portal To Manage Server Level IP Firewall Rules .