Greetings!
When attempting to move Azure SQL database resources from one region to another, you may encounter the error message "SQL server needs to be assigned manually." This occurs because moving the SQL server itself across regions is not supported. To resolve this issue, you need to create a new target server in the destination region and then move the resources from the source server to the new target server using Azure Resource Mover.
Follow these steps to move your resources:
1. Create a target server in the destination region.
- Move the resources from the source server to the target server using Azure Resource Mover.
- Configure any necessary logins and users on the target server.
For detailed steps, please refer to the following documentation:
- Move Azure SQL resources between regions with Azure Resource Mover
- Configure security for disaster recovery - Azure SQL Database
Hope this helps. If you have any follow-up questions, please let me know. I would be happy to help.
Please do not forget to "up-vote" wherever the information provided helps you, as this can be beneficial to other community members.
Regards
Geetha