1. Install Microsoft SQLServer

Create the druid user

• Create a druid user, enter when prompted for the password.

• Databases - New Database

1. Add the Microsoft JDBC library to the Druid classpath

• To ensure the com.microsoft.sqlserver.jdbc.SQLServerDriver class is loaded you will have to add the appropriate Microsoft JDBC library (sqljdbc*.jar) to the Druid classpath.

1. Configure your Druid metadata storage extension:

Add the following parameters to your Druid configuration, replacing with the location (host name and port) of the database.