Azure / Azure/azure-cli-extensions

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

Open
#8,894 2 comments 0 reactions 0 assignees View on GitHub
App Services Auto-Assign bug customer-reported extension/webapp Service Attention Web Apps
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.