Connectivity error with certain SQL connector actions in logic app designer

Matthew O'Connor 5 Reputation points
2024-04-04T08:38:35.2466667+00:00

In the logic app designer we are seeing the following connectivity error with certain SQL connector actions

Error code: 'NotFound', Message: 'Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) clientRequestId: ceb1c5a8-316f-4d4e-9e46-f78ebc0cec5c'. More diagnostic information: x-ms-client-request-id is 'D31166EA-1231-4F02-9A5C-1D83AC6E6465'.

The logic app executes fine despite this error.

User's image

You can see that if we use the 'Execute a SQL query (V2)' action, we don't see the error, whereas if we use a different action, e.g. 'Insert row (V2)' or 'Execute a stored procedure (V2)' we get the error above.

How can we remove this error from the designer?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,140 questions
0 comments No comments
{count} votes

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.