Hey folks,
I am trying to establish a connection between CloverETL and MS SQL 2012 using integrated JDBC driver. I used JDBC driver for MS SQL Server 08 -12. Unfortunately I can not access the SQL server, since it only accepts Windows auth. logins. My windows credentials have full admin rights on the server. I also tried to create a local SQL user “clover” on the server. I know that the JDBC URL used is correct, since I can view the failed login attempts in SQL server log which also tells me that only windows authentication is allowed.
The next thing I tried is to setup a connection via ODBC. Therefore I created a User DSN OBDC driver SQL Server (Version 6.03.9600.17415) and OBDC Driver 13 for SQL server. I followed the documentation (http://doc.cloveretl.com/documentation/ … izard.html) and tried to connect via Generic ODBC (JDBC specific: Generic ODBC and MS SQL Server 08 12) with ODBC URL jdbc:odbc:[Name of User DSN]; which result in error message:
Cannot create JDBC driver ‘Generic ODBC’. Cannot find class.
Class with the specified name cannot be found: sun.jdbc.odbc.JdbcOdbcDriver
I googled this and saw that JDBC-ODBC bridge has been removed in Java 8. Java on the machine is 1.7.0_80. So I assume this wouldn’t be the problem?
I would be very thankful if someone could help me out here! Also I want to avoid changing SQL server to mixed mode. So I want to connect via Windows Authentication.
Thanks in advance!