Can not perform requested operation on nested resource. Parent resource not found

Question

Hi,

When I tried to use az SQL import, I'm getting the following error,
what might be the cause and solution for this?
I went through this https://learn.microsoft.com/en-us/azure/azure-resource-manager/templates/error-parent-resource
but it didn't help, I have created the resources one after another.

az sql db import --resource-group "test" --server "testsqlsvr.database.windows.net" --name "TEST_DB"   
--storage-key-type "StorageAccessKey" --storage-key "wegfiajebfkjsbfiusdkbszzzzzxxxxxxxxxxxxxxxxx==" --storage-uri "https://test/asdb.bacpac" -u "user" -p "password"  
Can not perform requested operation on nested resource. Parent resource 'testsqlsvr.database.windows.net/TEST_DB' not found.  

What I am trying to do is, importing the data azure sql server from the bacpac.

Answer 1

Hi @pragadeeshraju-2799, you need to change the server's fully qualified name from '--server "testsqlsvr.database.windows.net"' to '--server "testsqlsvr" '.

Below is the command you can use:

az sql db import --resource-group "test" --server "testsqlsvr" --name "TEST_DB"
--storage-key-type "StorageAccessKey" --storage-key "wegfiajebfkjsbfiusdkbszzzzzxxxxxxxxxxxxxxxxx==" --storage-uri "https://test/asdb.bacpac" -u "user" -p "password"

---

If an Answer is helpful, please “Accept Answer” or Up-Vote for the same which might be beneficial to other community members reading this thread.

Answer 2

The error indicates that it cannot find the database you are trying to import into. Az sql db import imports a bacpac into an existing DB, so you must have already created that DB and server before running this command. If you have already created this, make sure that the Azure CLI is configured to use the subscription that the DB is in using az account set --subscription