MS SQL Server Connector - Error when setting Hostname (Server contains Named Instance with Flow Variable)

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.".

 

After troubleshooting a bit more i found that if i removed the named instance from the connection string altogether it worked. The port number is explicit to the named instance so it is essentially not needed in the connection string.