SQL Server Storage Plugin not Working

2019-08-10 15:57发布

问题:

I am trying to get the SQL Server Plugin working in Apache Drill as outlined here but it seems to be throwing the following error:

error (unable to create/update storage)

My storage config looks like this:

{
  type: "jdbc",
  enabled: true,
  driver: "com.microsoft.sqlserver.jdbc.SQLServerDriver",
  url:"jdbc:sqlserver://10.60.68.145;databaseName=Demo",
  username:"ApacheDrill",
  password:"Passw0rd"
}

I have tried copying both sqljdbc41.jar (from sqljdbc_4.1.5605.100_enu.tar.gz) and sqljdbc42.jar (from sqljdbc_4.2.6420.100_enu.tar.gz) to the drill directory \apache-drill-1.4.0\jars\3rdparty\ but it doesn't seem to make a difference.

The environment details are: Operating System: Microsoft Windows 8.1 Pro, SQL Server Version: 11.0.3000 and Apache Drill Version: 1.4.0.