OpenSQLConnection SSPI Library Not Loaded

2

1

I am attempting to open a connection to SQL Server with Windows Authentication (SSPI) using OpenSQLConnection and JDBC.

dbConn = OpenSQLConnection[JDBC["Microsoft SQL Server(jTDS)", "servername/dbname"]]

However, I am getting the following error from this.

JDBC::error: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property. >>

How do I load the "Native SSPI" library so that this connection can be opened?

I need to use integrated security so cannot pass in the username/password combo. The jTDS feature matrix says that it supports Window Authentication and Mma appears to be using the latest version of the driver (1.3.1).

JDBCDrivers["Microsoft SQL Server(jTDS)"]
(*
JDBCDriver["Name" -> "Microsoft SQL Server(jTDS)", 
 "Driver" -> "net.sourceforge.jtds.jdbc.Driver", 
 "Protocol" -> "jdbc:jtds:sqlserver://", "Version" -> 3., 
 "Description" -> 
  "Microsoft SQL Server using jTDS - Version 1.3.1 - This supports \
   Microsoft SQL Server 6.5, 7, 2000, 2005, 2008, and 2012.", 
 "Location" -> 
  "C:\\Program Files\\Wolfram \
   Research\\Mathematica\\10.0\\SystemFiles\\Links\\DatabaseLink\\\
   DatabaseResources\\sqlserverjtds.m"]
*)

Edmund

Posted 2015-03-26T14:25:06.820

Reputation: 35 657

Question was closed 2015-10-21T02:52:22.790

2

Have you been through this post in detail? http://mathematica.stackexchange.com/questions/10312/microsoft-sql-databaselink-connection-using-windows-authentication?rq=1

– Gordon Coale – 2015-03-26T17:56:37.803

Thanks @GordonCoale . That did the trick. If it is just a matter of including an open source DLL in the install I wonder why Wolfram doesn't include it? – Edmund – 2015-03-26T23:18:17.393

I tend to agree. It took me 2 days to get the oracle jdbc driver working. – Gordon Coale – 2015-03-27T06:25:23.133

Admins, think you can merge this question with http://mathematica.stackexchange.com/questions/10312/microsoft-sql-databaselink-connection-using-windows-authentication?rq=1 as it is solved by the process in that answer.

– Edmund – 2015-03-27T12:28:40.697

No answers