Database Alter & Delete greyed out

NicolaiH

I have moved a few NAV databases to Azure SQL. When I open any of these databases I cannot select the File > Database > Alter or File > Database > Delete options, these options are greyed out. The only two reasons I can come up with is that is must be the user rights on my Azure SQL user or maybe the license file, but the user is both db_owner and the equivelant to sys_admin on Azure SQL, and I tried using our developer license.

The problem is the same in both single- and multitenant databases.

I hope someone here has a solution or any suggestion I can try out.

Thanks!

Best regards
Nicolai

NicolaiH

Stumled into this, when I was looking for something else https://msdn.microsoft.com/en-us/library/hh165364(v=nav.90).aspx

"You cannot alter a database by using the development environment if the database is deployed on Azure SQL Database."

Peter+is1

Hi,

I think Azure SQL does not support all of the options available in the Alter Database forms. So perhaps that is why it/they is/are disabled.

NicolaiH

That could be it But it is still strange that I can't delete a database.

Thank you for your answer

NicolaiH

Stumled into this, when I was looking for something else https://msdn.microsoft.com/en-us/library/hh165364(v=nav.90).aspx

"You cannot alter a database by using the development environment if the database is deployed on Azure SQL Database."