SQL DB not Found

Question

Hi,

I have created SQL Server with multiple SQL Database in it, but when I try to click the Database in the Azure Portal, it says Resource Not Found, I can connect to the same database in the SQL Server Management Studio, I have also tried getting the usage of the server by running the Azure CLI command

az sql db list-usages --name 'db-name' --resource-group 'rg-dev' --server 'sqlserver-weu-nonprod'

And I am getting this in the terminal.

(ResourceNotFound) The Resource 'Microsoft.Sql/servers/sqlserver-weu-nonprod/databases/dbwtest' under resource group 'rg--weu-dev' was not found. For more details please go to https://aka.ms/ARMResourceNotFoundFix

Code: ResourceNotFound

Message: The Resource 'Microsoft.Sql/servers/sqlserver--weu-nonprod/databases/dbtest' under resource group 'rg-dev' was not found. For more details please go to https://aka.ms/ARMResourceNotFoundFix

Answer 1

This usually means one of these situations is happening:

1. Wrong resource group
2. Wrong subscription
3. Database was restored/imported differently
4. Portal cache/desync issue
5. Typo/case mismatch in server or DB Name

The important clue is "You can connect successfully from SQL Server Management Studio".

That means:

1. Logical SQL endpoint is reachable
2. database with that name is responding via the SQL engine
3. connectivity/authentication is working