I'd like to access a table on a MS SQL Server (Microsoft). Is it possible from Databricks?

To my understanding, the syntax is something like this (in a SQL Notebook):

CREATE TEMPORARY TABLE jdbcTable

USING org.apache.spark.sql.jdbc

OPTIONS ( url "jdbc:sqlserver://aaaa.database.windows.net;DatabaseName=bbbb;user=xxx;password=yyy",

The following error occurs: Error in SQL statement: SQLException: No suitable driver found for jdbc:sqlserver

Some research brought me here: https://spark.apache.org/docs/1.3.0/sql-programming-guide.html#jdbc-to-other-databases

Based on this sentence: "To get started you will need to include the JDBC driver for you particular database on the spark classpath." I uploaded the sqljdbc4.jar in the library and attached to the cluster, but unfortunately the error still occurs.

I'd very much like to do this in either R or SQL, unfortunately I don't know Java or Scala that well, Python is so-so.

I'm relatively new to Spark - any help is much appreciated!