Azure SQL JavaBridgeServer encountered an unknown error

[Dan]

We're using DB Connect to connect to an SQL Azure database from Splunk 5.0.2 running on Windows 8.

We installed the appropriate JDBC driver, copied into dbx/bin/lib, restarted splunkd and configured the database. We went to validate the database using the check box and we get "JavaBridgeServer encountered an unknown error" - no other information in jbridge.log or splunkd.log

[Dan]

dbx.log should contain more information about errors when connecting to databases.

You should not need to add a JDBC driver. The driver we ship for MS SQL Server (jTDS) should work.
http://blogs.msdn.com/b/nickhodge/archive/2010/01/25/jdbc-to-sql-azure.aspx

Unfortunately, I just saw that we're overriding the JDBC URL parameter "ssl" with "request". Seems like Azure requires it to be set to "require". Since this is a trivial change, I've created an intermediate build.

Please contact Splunk support for access to this build

You have to configure the database in the configuration file (database.conf):

[azure]
host = <server>.database.windows.net
database = <database>
username = username@server
password = ....
arg.ssl = require