New-AzureRmResourceGroupDeployment command gives an error

Question

When I run New-AzureRmResourceGroupDeployment and pass the JSON parameter file, I get the following error:

New-AzureRmResourceGroupDeployment : 2:29:31 PM - Resource Microsoft.Sql/servers 'qsservername' failed with message '{ "code": "15021", "message": "Invalid value given for parameter Login. Specify a valid parameter value.", "target": null, "details": [ { "code": "15021", "message": "Invalid value given for parameter Login. Specify a valid parameter value.", "target": null, "severity": "16" } ], "innererror": [] }' At M:\Azure\Azure Scripts\Something\somethingdeploy.psm1:63 char:4 + New-AzureRmResourceGroupDeployment -ResourceGroupName $resourceGro ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [New-AzureRmResourceGroupDeployment], Exception + FullyQualifiedErrorId : Microsoft.Azure.Commands.ResourceManager.Cmdlets.Implementation.NewAzureResourceGroupDeploymentCmdlet 

However, when I run the same command, but pass the parameters instead of the file, it works fine. Any ideas what I might be missing?

Answer 1

For me, this error occurred when I tried to run ARM templates with an existing Azure SQL instance resource. The problem was that in the template I specified the database username that did not match the username for the existing instance. It's okay to update the password, but the username must remain the same for the life of the SQL Azure instance.