Connectivity error with certain SQL connector actions in logic app designer
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.
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?