Forum Discussion
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.
2 Replies
Nagesh_gMicrosoft
It seems you have given FQDN for server name twice which is why it is showing servername.database.windows.net.database.windows.net. It should be servername.database.windows.net.
You mentioned login name as Sana1, may i know why your using sanauser?Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Azure SQL space - please post Azure SQL questions here in the future.
