DP-800: Developing AI-Enabled Database Solutions

You have an Azure SQL database named ProductsDB.

You deploy Data API builder (DAB) to Azure Container Apps by using the mcr.microsoft.com/azure-databases/data-api-builder:latest image.

The container app has these configurations:

• Secrets: mssql-connection-string, dab-config-base64
• Environment variables:
  • MSSQL_CONNECTION_STRING=secretref:mssql-connection-string
  • DAB_CONFIG_BASE64=secretref:dab-config-base64
• Ingress: External on port 5000

Users report that the /health endpoint returns a healthy response, but every request that queries an entity named Products fails and produces a connection error.

You confirm that the SQL login in the connection string is correct and that the database exists.

You need to ensure that the container app can establish connections to the Azure SQL logical server without changing the container app deployment settings or the DAB configuration file.

What should you do on the Azure SQL logical server?