When trying to connect to a SQL Server Named Instance from Designer using the format "jdbc:tibcosoftwareinc:sqlserver://<host>:<port#>;databaseName=<databaseName>", the following error occurs when using the TIBCO Database Drivers supplement v 2.0.4 or above.
 
java.sql.SQLNonTransientConnectionException: [tibcosoftwareinc][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number.

Cause:
In older versions of the driver, when both instance name and port number were used, the driver connected using the instance name. Since the port number is not needed when a named instance is provided, the TIBCO Database Drivers supplement v 2.0.4 or above now returns an error when a user enters a port number with an instance name.