Highlighted

Hi I have Windows 2003 server with CF11 installed. also I have SQL Sever 2005 on different server. I can not connect to SQL database it shows error 'Connection verification failed for data source: DBTest java.sql.SQLNonTransientConnectionException: [Macro

New Here ,
Apr 19, 2015

Copy link to clipboard

Copied

Hi I have Windows 2003 server with CF11 installed. also I have SQL Sever 2005 on different server. I can not connect to SQL database it shows error 'Connection verification failed for data source: DBTest java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number. The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number." ?

Views

209

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Hi I have Windows 2003 server with CF11 installed. also I have SQL Sever 2005 on different server. I can not connect to SQL database it shows error 'Connection verification failed for data source: DBTest java.sql.SQLNonTransientConnectionException: [Macro

New Here ,
Apr 19, 2015

Copy link to clipboard

Copied

Hi I have Windows 2003 server with CF11 installed. also I have SQL Sever 2005 on different server. I can not connect to SQL database it shows error 'Connection verification failed for data source: DBTest java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number. The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number." ?

Views

210

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Apr 19, 2015 0
Guide ,
Apr 19, 2015

Copy link to clipboard

Copied

Hi Prushka,

Is SQL 2005 running as an instance?

If so you might like to try connecting to it like pictured removing the port number details.

Capture4.JPG

HTH, Carl.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Apr 19, 2015 0