java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

[sunny3]

Hi,

i am running a job and it has some mssql components.

 i am getting the below error:

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)

 could  you please tell me what might be the reason for it

[sarora1]

Looks like you are missing some jars. Is Talend not prompting you for which dll it wants?

[sunny3]

no it did not prompt for insatlling any jar,

[sarora1]

Check in your Java if you have dlls for sql server. I have sqljdbc_auth.dll since I am using integratedSecurity=true;

For me its in C:/Java/jre8x64/bin/sqljdbc_auth.dll  - YMMV 

And, if you add new dlls you need to restart studio.