Invalid connection in designer after deploy of SQL connection

Martin Peters 6 Reputation points
2024-08-01T15:25:11.5266667+00:00

I have an issue after a deploy in a clean resource group for a managed SQL connection. The connections.json looks as follows:

    "managedApiConnections": {
        "synapse-api": {
            "api": {
                "id": "/subscriptions/@{appsetting('SUBSCRIPTION_ID')}/providers/Microsoft.Web/locations/westeurope/managedApis/sql"
            },
            "authentication": {
                "identity": "@appsetting('MANAGED_IDENTITY_ID')",
                "type": "ManagedServiceIdentity"
            },
            "connection": {
                "id": "/subscriptions/@{appsetting('SUBSCRIPTION_ID')}/resourceGroups/@appsetting('ENVIRONMENT_RESOURCE_PREFIX')-rg-leadtocash-customer-01/providers/Microsoft.Web/connections/synapse-api"
            },
            "connectionProperties": {
                "authentication": {
                    "audience": "https://database.windows.net/",
                    "identity": "@appsetting('MANAGED_IDENTITY_ID')",
                    "type": "ManagedServiceIdentity"
                }
            },
            "connectionRuntimeUrl": "@{appsetting('CONNECTION_RUNTIME_URL')}"
        }
    },

After deploy, the connection works. When I open the designer it reports "Invalid connection". After I select the user assigned managed identity from the dropdown, a new connection is created in the connections.json file with the same content, except that appsettings are hardcoded. Then the designer is happy. Even if I deploy with hardcoded values the problem is the same. The API connection deploys fine and the access policy looks fine. I cannot see the difference between the connection which is deployed and the connection which is created using the portal. Did anyone had the same problem and found a way to solve it?

Screenshot 2024-07-30 091108

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,534 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.