How to copy an Azure SQL Database to a different server or subscription using Azure Automation.
I am trying to copy Azure SQL Database to a different server, and for this I am following this document https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-copy-an-azure-sql-database-to-a-different-server-or/ba-p/2649689?fbclid=IwAR1s8kWjlk6uEwFEJQ5eq5tYknhDqJXT64YuNtfvvN7cwJRZpNU6xywQhr8 I used same credentials for user and login creation at source and destination server. I captured the SID of a user from source server and created a login with the same SID at destination server. login name: Sana1 username: sanauser I performed the same steps mentioned in the document for automation account creation. Now, i'm getting below errors with two different scenarios: In the credential tab when i am using Login Name in the user name field - 2. In the credential tab when i am using User Name in the user name field - I am not able to connect to destination server to copy database by using above steps. Anyone can help me out with this.
