Creation of Microsoft SQL Server data source using Data Direct JDBC driver fails with error "When the instance name is specified, it is invalid to specify the port number" in TIBCO Spotfire

Creation of Microsoft SQL Server data source using Data Direct JDBC driver fails with error "When the instance name is specified, it is invalid to specify the port number" in TIBCO Spotfire

When creating a data source in the Information Designer (see Creating a Data Source in Information Designer for more details) for a Microsoft SQL Server using the TIBCO Data Direct Driver and including a port number along with the instance name in the connection string, it may fail with the following error message:

[tibcosoftwareinc][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number.

To resolve this issue, remove the port number from the JDBC connection URL.The port number is not needed when a named instance (see Instance Configuration for more details on using a default versus a named instance) is provided in the connection string. The following is an example connection string for your reference.

jdbc:tibcosoftwareinc:sqlserver://<host>\<instance>;databaseName=<databaseName>

Note: This is applicable for any JDBC connection to a Microsoft SQL Server named instance using the TIBCO Data Direct driver, including a TIBCO Spotfire Server bootstrap connection and Action Log configuration as well. Doc: Creating a Data Source in Information Designer

• https://docs.tibco.com/pub/sfire-analyst/10.3.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/id/id_creating_a_data_source.htm

External: Instance Configuration

• https://docs.microsoft.com/bs-cyrl-ba/sql/sql-server/install/instance-configuration?view=sql-server-2014v