I am attempting to create a new connection to a SQL Server 2012 database.
Hostname: DTISADMPDBS39\THIRTYNINE2012
Port: 49534
Database: JCO_OrgData
I have installed the jtds-1.2.5.jar
When configuring the DataSource, the connection fails.
Driver = net.sourceforge.jtds.jdbc.Driver
URLs attempted:
jdbc:jtds:sqlserver://DTISADMPDBS39\THIRTYNINE2012:49534/JCO_OrgData
jdbc:jtds:sqlserver://DTISADMPDBS39\THIRTYNINE2012/JCO_OrgData
jdbc:jtds:sqlserver://DTISADMPDBS39:49534/JCO_OrgData
jdbc:jtds:sqlserver://DTISADMPDBS39/JCO_OrgData
jdbc:jtds:sqlserver://172.16.4.89:49534/JCO_OrgData
jdbc:jtds:sqlserver://172.16.4.89/JCO_OrgData
My attempts to connect are seen by the database server. The User Name in my config has been given rights to view.
Anyone see what I am missing?