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

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:
jdbc:tibcosoftwareinc:sqlserver://USSCLNEDBSEA001\ODSGDEV2;databaseName=common

Additional Information

https://knowledgebase.progress.com/articles/Article/000033727