Why cant servers be recognized in Azure Logic Apps?

user_13495765 0
Viewed 562

I have created a Logic App and set a Sliding Window. I have added the next step as Execute a SQL Query (V2) but if i put the server name in there it gives an error

Could not retrieve values. Error code: '400', Message: 'Invalid connection settings inner exception: 
Key 
'token' in connection profile is not valid. inner exception: Unexpected character encountered while 
parsing value: h. Path '', line 0, position 0. clientRequestId: ????
azure-logic-apps
1 Answers

If you set admin for your sql server with service principal, it may show this error message. You can create a group and add the service principal or ad users into a group. And then set sql admin for the group.

Here is a similar post which may help you.

user_110992130
Related