H everyone, when using the SQL Insert Row Trigger I can view all tables from my SQLServer, but I need to use the trigger to run a stored procedure but continually receive this error:
"Could not retrieve values. 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)"
Driving me crazy...Any ideas?
Did your flow work well with an action “Insert row” to SQL Server?
Is the connection of “Execute stored procedure” action same with the connection of “Insert row” action?
Many thanks for your reply.
Remote connections are allowed to the SQL database (on premises) and all other SQL actions (get, insert etc) work. Also this is going via on-premise data gateway.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks