Unable to load the driver: net.sourceforge.jtds.jdbc.Driver SQL SERVER 2008

[miland]

I'm having the exact same problem as http://forums.pentaho.org/showthread...load+driver%3A

I put sqljdbc.jar in C:\Pentaho\server\biserver-ce-3.5.0.stable\administration-console\jdbc and in
C:\Pentaho\server\biserver-ce-3.5.0.stable\biserver-ce\tomcat\common\lib. Report works fine in PRD. Duplicated the data source name in PAC as well. Can't get the report to load in the BI Console though:

Failed to open the connection: java.sql.SQLException: Unable to load the driver: net.sourceforge.jtds.jdbc.Driver

Any ideas?

Thanks,
David

[miland]

The solutions for me was to get the right "jar" in the right place.

1) Go to http://sourceforge.net/projects/jtds/ and download the latest Open source JDBC driver
2) Extract jtds-1.2.4.jar to ~\biserver-ce-3.5.0.stable\biserver-ce\tomcat\common\lib. Probably should do that for ~\biserver-ce-3.5.0.stable\administration-console\jdbc too.
3 Restart the BI Server (and PAC).

Should work now.

Thanks,
David