az webapp connection create sql fails on Azure Cloud Shell and requires odbc install

[ChristophHornung]

Describe the bug

When trying to set up a connection from my Azure App Service to an SQL DB via the Service Connector the azure cloud shell command fails:

az extension add --name serviceconnector-passwordless --upgrade
az webapp connection create sql --connection <Name> --source-id <myAppServiceSlot> --target-id <mySqlServer+Database>" --client-type dotnet --system-identity
The behavior of this command has been altered by the following extension: serviceconnector-passwordless
Checking if WebApp enables System Identity...
Connecting to database...
Please manually install odbc 17/18 for SQL server, reference: https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server/

this used to work before, and it is unclear on how to even install odbc for sql server on an Azure Cloud Shell.

Related command

az webapp connection create sql --connection --source-id --target-id <mySqlServer+Database>" --client-type dotnet --system-identity

Errors

Please manually install odbc 17/18 for SQL server, reference: https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server/

Issue script & Debug output

logazc.txt

Expected behavior

It just works

Environment Summary

azure-cli 2.71.0 *

core 2.71.0 *
telemetry 1.1.0

Extensions:
ai-examples 0.2.5
ml 2.36.4
serviceconnector-passwordless 3.3.4
ssh 2.0.6

Dependencies:
msal 1.31.2b1
azure-mgmt-resource 23.1.1

Python location '/usr/bin/python3.12'
Config directory '/home/christoph/.azure'
Extensions directory '/home/christoph/.azure/cliextensions'
Extensions system directory '/usr/lib/python3.12/site-packages/azure-cli-extensions'

Python (Linux) 3.12.9 (main, Mar 11 2025, 15:30:57) [GCC 13.2.0]

Legal docs and information: aka.ms/AzureCliLegal

Additional context

No response

[yonzhan]

Thank you for opening this issue, we will look into it.

[microsoft-github-policy-service]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @AzureAppServiceCLI, @antcp, @yutanglin16.