az sql db export with long string password failed in Azure pipeline and local machine and succeed with azure cloud shell.

[zhutian33]

Run az sql db export --resource-group ''
--subscription '' -a SQL -s '' -n '' -p '' -u '' --storage-key '' --storage-key-type 'StorageAccessKey' --storage-uri '' --verbose with long string password (127 characters long with letters, digit and ^#*!% ) in Azure could shell could successfully export the database to storage account. But run the same command in Azure pipeline failed with error: ERROR: (ImportExportJobError) The ImportExport operation with Request Id '' failed due to 'The username or password for the given SQL server is incorrect.'. Code: ImportExportJobError Message: The ImportExport operation with Request Id '' failed due to 'The username or password for the given SQL server is incorrect.'. [Enter feedback here] The problem can be reproduced on the machine that runs the pipeline. I have set up a self-hosted agent and run pipeline on the machine, problem can be reproduced. Now, the CLI with such long password can only run successfully on the cloud shell in Azure portal. (The version of CLI in Azure portal, VM and Microsoft hosted agent are all the same -- 2.44.1)

If I change the password as Abc@123, it works well in azure could shell, azure pipeline and local machine.

Please help to check the password field for invalid character and length in Azure CLI.

failed due to 'The username or password for the given SQL server is incorrect.'

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: c1bdd674-b454-e863-c943-9c979b466a92
• Version Independent ID: b15341f9-3f1b-00e0-a1c2-970f25a6ab03
• Content: az sql db
• Content Source: latest/docs-ref-autogen/sql/db.yml
• Service: sql-database
• GitHub Login: @rloutlaw
• Microsoft Alias: routlaw

[yonzhan]

route to CXP team

[darena-patrick]

what's going on with this one? i've got same issue and it's causing me some issues