The 'parameters.properties.administratorLoginPassword' segment in the url is invalid.

David Haver 25 Reputation points
2023-05-17T15:34:43.0266667+00:00

I am deploying an Azure SQL Database via an ARM Template. The Administrator login information is contained in an azure Key Vault. The deployment is failing and the error states "The 'parameters.properties.administratorLoginPassword' segment in the url is invalid.'

Here are the snipets of code:

In parameters is

"SQL_Admin_Account": {
            "type": "string",
            "metadata": {
                "description": "This is where the description goes."
            },
            "defaultValue": "pxise-admin"
        },

In variables is

"SQL_Admin_Password": {
            "reference": {
                "keyvault": {
                    "id": "/subscriptions/ef9ec5b1-5530-4858-99a4-1ec9e3d1cc00/resourceGroups/PXiSE_Deployment_RG/providers/Microsoft.KeyVault/vaults/pxise-kv"
                },
                "secretName": "SQL-Admin-Password"
            }
        },

In resources I have this

{
            "type": "Microsoft.Sql/servers",
            "apiVersion": "2022-08-01-preview",
            "name": "[parameters('SQL_server_name')]",
            "location": "[parameters('location')]",
            "tags": {
                "Environment": "[parameters('environment_type')]"
            },
            "kind": "v12.0",
            "properties": {
                "administratorLogin": "[parameters('SQL_Admin_Account')]",
                "administratorLoginPassword": "[variables('SQL_Admin_Password')]",
                "version": "12.0",
                "minimalTlsVersion": "1.2",
                "publicNetworkAccess": "Enabled",
                "restrictOutboundNetworkAccess": "Disabled"
            }
        },

This is the raw error that I am getting

{
  "code": "InvalidResourceIdSegment",
  "message": "The 'parameters.properties.administratorLoginPassword' segment in the url is invalid.",
  "details": [
    {
      "code": "InvalidResourceIdSegment",
      "target": "parameters.properties.administratorLoginPassword",
      "message": ""
    }
  ]
}

What am I doing wrong?

Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,316 questions
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.