topic Re: sophos sql server odbc connect in Deployment Architecture

sophos sql server odbc connect

manojs888 — Wed, 31 Jul 2013 17:17:52 GMT

Hi, How do I connect splunk to retrieve from SQL Server (I have a sophos SQL server dtabase) ?

Thx

Re: sophos sql server odbc connect

Gilberto_Castil — Wed, 31 Jul 2013 17:42:07 GMT

We have a utility in Splunkbase called Splunk DB Connect.

Re: sophos sql server odbc connect

manojs888 — Fri, 02 Aug 2013 11:33:44 GMT

Thx,

I get the following error when trying to add a db connection.

Encountered the following error while trying to save: In handler 'dbx-databases': Error connecting to database: java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property

Re: sophos sql server odbc connect

Gilberto_Castil — Fri, 02 Aug 2013 13:46:20 GMT

We are assuming that you have done this:

The following are required before deploying Splunk DB Connect:

A Java Runtime Environment (JRE) Version 1.6 or above
    Do not use a hotspot (client mode only) JVM.
    http://www.oracle.com/technetwork/java/javase/downloads/index.html

You will also need to set up JAVA_HOME as a global variable in your system.

Java Installation directory (JAVA_HOME): This must be the directory of your Java JRE (Runtime Environment). The default value will be retrieved by your JAVA_HOME environment variable (if set properly).

http://bit.ly/13sfWOv