CONTROL DATABASE issue when migrating SQL database to Azure

Question

I'm following this tutorial on Microsoft Docs. I've reached the part where I use the "Data Migration Assistant", but after selecting the target Azure database and clicking "Next", I get the following error:

An unexpected error occurred. Current principal does not have CONTROL permission on securable AzureDatabaseName of class DATABASE.

I'm using the only user of the Azure SQL server - the server admin, which should have all permissions. I've verified that the user is 'db_owner' by using IS_ROLEMEMBER.

Am I missing something?

Answer 1

I had the same issue. This seems to be a bug in Azure SQL databases. If you have dots in the database name it does not work. I replaced the dots with slashes and it worked for me.

You do not need to recreate the database. A rename worked fine for me:

1. You have to make sure, that no-one else is using the database!

2. Connect to master table and execute the following script on the Azure SQL Server:

   USE master;
   GO
   ALTER DATABASE [my.database] Modify Name = [my-database] ;
   GO

Here is a link on how to rename Azure SQL databases:

https://learn.microsoft.com/en-us/sql/relational-databases/databases/rename-a-database

Answer 2

Also make sure to create a firewall rule for your incoming connection. This error can be a bit of a red herring.

Answer 3

I deleted everything - the database, the sql server, and the resource group. Then I recreated everything using the same names, except the database name - which previously contained dots - and this time the migration tool worked. I guess I just encountered some bug.