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

Dhananjay Tripathi 0 Reputation points
2024-11-04T15:09:03.8333333+00:00

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.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,249 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.
14,147 questions
{count} votes

1 answer

Sort by: Most helpful
  1. LeelaRajeshSayana-MSFT 16,701 Reputation points
    2024-11-04T18:35:47.32+00:00

    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.

    0 comments No comments

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.