Error: Validation failed When Create SQL Database

Steve Wang 31 Reputation points
2021-09-02T15:03:12.117+00:00

Hello,

I am new to Azure and learning it. An error occurred when I am trying to create SQL database in Azure.

128783-image.png

The Raw Error:

{
"code": "InvalidDeploymentParameterValue",
"message": "The value of deployment parameter 'digestRegion' is null. Please specify the value or use the parameter reference. See https://aka.ms/resource-manager-parameter-files for details."
}

I am using an Azure free account and I checked the free account limit, it shows that 250 GB of Azure SQL Database standard S0 instance with 10 database transaction units is allowed.

I also tried to change the Sqlserver region to different regions, but the same error occurred.

When I checked the deployment template and search for "Region", the 'digestRegion' parameter is actually empty. I guess it should be the region name. Where should I find the applicable options? Thank you!

128687-image.png

128811-image.png

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Basudeb Sarkar 81 Reputation points
    2021-09-02T18:44:40.223+00:00

    Thanks, The deployment for the fix is in progress and will be completed in couple of hours from now.

    1 person found this answer helpful.

5 additional answers

Sort by: Most helpful
  1. Donovan Matson 1 Reputation point
    2022-09-05T18:26:46.257+00:00

    I'm getting a similar error but not with region. instead it seems to be something about the template parameter 'minCapacity' receiving an invalid value. States it received an integer when it expected 'String, Uri' value type. I'll post the exact error below. Might create a new thread for this one if it isn't related to the issue in here.

    Deployment template validation failed: 'Template parameter 'minCapacity' was provided an invalid value. Expected a value of type 'String, Uri', but received a value of type 'Integer'. Please see https://aka.ms/resource-manager-parameter-files for usage details.'. (Code: InvalidTemplate)

    (edit) so here's a link to my issue directly if anyone is willing to assist me outside of this thread. If a mod doesn't beat me to it I'll delete this comment once I start receiving answers on my thread that I created.

    https://learn.microsoft.com/en-us/answers/questions/994783/using-microsoft-learn-sandbox-to-create-a-database.html