AnsweredAssumed Answered

JDBC Step - MSSQL DB connection error

Question asked by ShijilJanardhan4209079 on Aug 27, 2014
Latest reply on Aug 28, 2014 by ShijilJanardhan4209079


Hi,

 

I'm having issue connecting to a mssql server using JDBC step in lisa 7.5. I used below driver and connection string as per the default format and I get error. I'm I using it wrong?

 

driver                           : com.microsoft.sqlserver.jdbc.SQLServerDriver
connecting string     : jdbc:microsoft:mysql://{{server}}:1433

 

Error : Message: Connection failed. Please check your settings to ensure they are correct. If you are using MSSQL you need to match the URLs with the driver. They are slightly different.

 

I changed the connection string slighly - without the'microsft' in it and got below error.

jdbc:sqlserver://{{server}}:1433 - without the 'microsoft' in it

Error : java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
Thanks in Advance

Outcomes