How to authenticate Logic Apps(Standard) using SPN to connect to SQL server in AzureUSGovernment?

Rachel I 5 Reputation points
2023-10-27T14:15:58.61+00:00

I need to query from the built-in SQL Server connector in Logic Apps(Standard) with Service Principal authentication. The Logic App and SQL Server are in the same subscription under AzureUSGovernment. My Service Provider connection has below information: authProvider:

  • CredentialTYpe: Secret
  • Tenant: xxx
  • ClientId: xxx
  • Secret: xxx
  • Type: ActiveDirectoryOAuth serverName: xxx databaseName: xxx serviceProvider:
  • id: /serverProvider/sql

When I run the logic app, I would get "AADSTS900382: Confidential Client is not supported in Cross Cloud request". I'm thinking that I need to indicate somewhere that the environment = AzureUSGovernment. I tried adding "Environment" under authProvider but error displayed as Unsupported names as "Environment".

Is there a way to specify that connection is government?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,927 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,051 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Rachel I 5 Reputation points
    2023-10-30T20:54:38.37+00:00

    Authority was needed to be added to the authprovider.

    1 person found this answer helpful.

  2. Vahid Ghafarpour 19,710 Reputation points
    2023-10-30T02:38:25.8666667+00:00

    You can use managed identities to authenticate your connection to SQL Server by API connection using credentials kept in key vault.

    https://techcommunity.microsoft.com/t5/azure-integration-services-blog/integrate-logic-apps-with-sql-server-by-api-connection-using/ba-p/3789081