Hi,
I am trying to create a manually triggered flow that uses the "get rows" action, however when using the SQL server connector (or the Azure Database for MYSQL connector), the server name will not load in the drop-down even though I have successfully connected to both connectors using the Azure AD integrated authentication method (shown as successful connections in the connections tab on the online portal).
I have tried refreshing the connection, signing in and out, entering the server and database name manually as custom values (with and without port numbers), but I get the following error:
Could not retrieve values. The dynamic invocation request failed with error: {
"status": 404,
"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: TCP Provider, error: 0 - No such host is known.)\r\nclientRequestId: bdda1d6e-3d6d-46d6-9b2c-af59da0c4028",
"error": {
"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: TCP Provider, error: 0 - No such host is known.)"
},
"source": "sql-ne.azconn-ne-002.p.azurewebsites.net"
}.
I have no issue connecting and creating flows using the same server/database using the Power BI connector for example. Any suggestions? I'm completely stumped!
