Authority was needed to be added to the authprovider.
How to authenticate Logic Apps(Standard) using SPN to connect to SQL server in AzureUSGovernment?
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?
2 answers
Sort by: Most helpful
-
-
Vahid Ghafarpour 20,500 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.