Issue while connecting on-prem SQL server from Logic App standard workflow

Question

Issue while connecting on-prem SQL server from Logic App standard workflow

Dhananjay Tripathi 0

Hello community members,

I am trying to connect to on prem SQL server via Logic apps(standard) using on-prem data Gateway. I am getting below error while trying to connect.

Failed to retrieve dynamic inputs. Error details: 'Error code: 'BadRequest', Message: 'Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Execute Native Sql) is currently not supported using an on-prem gateway connection clientRequestId: 35d717d8-7f5f-4258-be40-eabfcaf47073'.'

Do anyone has faced and what is resolution to same.

Thanks,

Dhananjay.

LeelaRajeshSayana-MSFT 17,866 Reputation points Moderator

2024-11-08T01:13:34.3066667+00:00

Hi @Dhananjay Tripathi We still have not heard back from you. Just wanted to check if the answer provided below was helpful? If it answers your query, please do click Accept Answer and Yes for the answer, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know. Thank you
LeelaRajeshSayana-MSFT 17,866 Reputation points Moderator

2024-11-11T15:06:09.2266667+00:00

Hi @Dhananjay Tripathi We still have not heard back from you. Just wanted to check if the answer provided below was helpful? If it answers your query, please do click Accept Answer and Yes for the answer, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know. Thank you

1 answer

Your answer

LeelaRajeshSayana-MSFT 17,866 Reputation points Moderator

2024-11-08T01:13:34.3066667+00:00

Hi @Dhananjay Tripathi We still have not heard back from you. Just wanted to check if the answer provided below was helpful? If it answers your query, please do click Accept Answer and Yes for the answer, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know. Thank you
LeelaRajeshSayana-MSFT 17,866 Reputation points Moderator

2024-11-11T15:06:09.2266667+00:00

Hi @Dhananjay Tripathi We still have not heard back from you. Just wanted to check if the answer provided below was helpful? If it answers your query, please do click Accept Answer and Yes for the answer, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know. Thank you

Answer 1

Hi @Dhananjay Tripathi Greetings! Welcome to Microsoft Q&A forum. Thank you for posting this question here.

I believe you are trying to use the Execute a SQL query (V2) action using the connection which is where you encounter this issue. According to the documentation, this current action is not supported for on-premises SQL server. Please refer to the point 2 of the article section - Known issues and limitations with actions which outlines this limitation.

There is a feedback request item logged by the users on the ideas forum to implement this feature. I am sharing the link here for your reference - Support for SQL Query using On-Premise SQL Servers I request you to kindly upvote the idea.

If the response helped, please do click Accept Answer and Yes for the answer provided. Doing so would help other community members with similar issue identify the solution. I highly appreciate your contribution to the community.

Share via

Issue while connecting on-prem SQL server from Logic App standard workflow

1 answer

Your answer