We have a data lake in here that uses MS SQL Server 12.02 and connects using the active directory integrated services authentication.

The standard driver would not work

<< "DatabaseLink`"
sqlStandard = 
   JDBC["Microsoft SQL Server(jTDS)", 
   "Name" -> "DataLake", "Catalog" -> Automatic,"Description" -> None, "ReadOnly" -> Automatic, 
   "RelativePath" -> False, "TransactionIsolationLevel" -> Automatic,"UseConnectionPool" -> Automatic];

connStandard = OpenSQLConnection[sqlStandard]

(*JDBC::error: The syntax of the connection URL 'jdbc:jtds:sqlserver://myserver;DatabaseName=dw-scv-prod;authentication=ActiveDirectoryIntegrated' is invalid.*) 

I downloaded the MS SQL driver from Microsoft


and installed it under C:\Users\myuser\AppData\Roaming\Mathematica\Applications\Oracle\Java

also placed the following dll driver in


in the same directory.

sqlMS = SQLConnection[
   JDBC["com.microsoft.sqlserver.jdbc.SQLServerDriver", "jdbc:sqlserver://myserver;DatabaseName=dbprod;authentication=ActiveDirectoryIntegrated"], 
   "Name" -> "DataLake", "Catalog" -> Automatic, 
   "Description" -> None, "ReadOnly" -> Automatic, 
   "RelativePath" -> False, "TransactionIsolationLevel" -> Automatic, 
   "UseConnectionPool" -> Automatic];
connMS = OpenSQLConnection[sqlMS]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.