Azure / Azure/azure-cli-extensions
az webapp connection create sql fails on Azure Cloud Shell and requires odbc install
- Dominant language
- Python
- Stars
- 454
- Forks
- 1.7k
- Avg merge
- 2d 19h
- Merged PRs (30d)
- 64
Description
### 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:
```text
az extension add --name serviceconnector-passwordless --upgrade
az webapp connection create sql --connection --source-id --target-id " --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 " --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](https://github.com/user-attachments/files/20865307/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_
Contributor guide
Assessment
This issue has not been assessed yet.