mpartyka
10 years agoContributor
Trying to connect to SQL Database with jTDS driver
Using SoapUI Pro 5.1.1
Trying to connect to SQL Database with driver = com.microsoft.sqlserver.jdbc.SQLServerDriver but get the following error:
Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: The TDS protocol stream is not valid..[/move]
Read a similar post that suggested the jTDS driver at http://jtds.sourceforge.net/
Downloaded the jtds driver, unzipped & placed jar file in C:\Program Files\SmartBear\SoapUI-Pro-5.1.1\bin\ext
Under file /Preferences I added new driver
Driver = jTDS/net.sourceforge.jtds.jdbc.Driver
Connection String Template = jdbc:jtds:sqlserver://server:port/database;ssl=require;user=xxxx;password=xxxx
We don't want to use Windows authentication. Test connections just hang. Can you help ? Thanks M. Heeke
Trying to connect to SQL Database with driver = com.microsoft.sqlserver.jdbc.SQLServerDriver but get the following error:
Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: The TDS protocol stream is not valid..[/move]
Read a similar post that suggested the jTDS driver at http://jtds.sourceforge.net/
Downloaded the jtds driver, unzipped & placed jar file in C:\Program Files\SmartBear\SoapUI-Pro-5.1.1\bin\ext
Under file /Preferences I added new driver
Driver = jTDS/net.sourceforge.jtds.jdbc.Driver
Connection String Template = jdbc:jtds:sqlserver://server:port/database;ssl=require;user=xxxx;password=xxxx
We don't want to use Windows authentication. Test connections just hang. Can you help ? Thanks M. Heeke