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
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