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.