I am attempting to use the new MS SQL Server Connector.
When explicitly set the Hostname with Named Instance <database\instance> it works fine.
When i attempt to pass the same exact string into the flow variable it fails.
Error shows that it is trimming the "\instance" out prior to executing.
Execute failed: Could not create connection to database: The TCP/IP connection to the host <database>, port 53733 has failed. Error: "<database>. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".