New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

MS SQL server Driver issue

Solved!
Siva_sai
Level 1
MS SQL server Driver issue

Hi All,



I'm trying to create a MS SQL server connection and end up with following error. Can someone please help me to fix this error.



0 Kudos
1 Solution
Clément_Stenac
Dataiker
Dataiker
Hi,

You need to download and instal the JDBC driver as explained here:

https://doc.dataiku.com/dss/latest/troubleshooting/errors/ERR_SQL_CANNOT_LOAD_DRIVER.html

View solution in original post

4 Replies
Clément_Stenac
Dataiker
Dataiker
Hi,

You need to download and instal the JDBC driver as explained here:

https://doc.dataiku.com/dss/latest/troubleshooting/errors/ERR_SQL_CANNOT_LOAD_DRIVER.html

View solution in original post

Siva_sai
Level 1
Author
Thanks for the quick reply Stenac. I followed all the steps provided in that link already but still no luck.

Can we connect to MS SQL server with 2 weeks trail version license?
0 Kudos
Clément_Stenac
Dataiker
Dataiker
Hi, yes you can connect with the trial license.

Have you checked that in the "lib/jdbc" subfolder of the DSS datadir, you now have a "mssql-something.jar" ? Have you restarted DSS after adding it ? Is the error message exactly the same ? Can you attach a screenshot of both the error and the contents (ls -l) of lib/jdbc?
0 Kudos
Siva_sai
Level 1
Author
Thanks a lot Stenac. My bad, I copied the files into DataIKU/dataiku-dss-5.1.4/lib/jdbc instead of DataIKU/DATA_DIR/lib/jdbc path. Now I moved it to correct path and it's working fine.
0 Kudos
Labels (2)
A banner prompting to get Dataiku DSS