Error "Conflicting connection information. When the instance name is specified, it is invalid to specify the port number" when connecting to a SQL Server Named Instance
book
Article ID: KB0072886
calendar_today
Updated On:
Products
TIBCO Runtime Agent (TRA)
TIBCO Designer
Description
Connection to SQL server fails when using the TIBCO driver 2.0.4 (TIsqlserver.jar ) from TIBCO designer 5.10 with the below error stack. ------------------------
BW-JDBC-100034 "Configuration Test Failed. Exception [java.sql.SQLNonTransientConnectionException] occurred.
java.sql.SQLNonTransientConnectionException: [tibcosoftwareinc][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number."
--------------------------
In older versions of the driver, when both instance name and port number were used, the driver driver connected using the instance name. Since the port number is not needed when a named instance is provided, the driver now returns an error when a user enters a port number with an instance name.
Issue/Introduction
[DataDirect][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number.
Resolution
Remove the port number from the connection string. Below is a sample connection string with out the port number: