https://community.splunk.com/t5/Splunk-Search/DB-Connect-with-instance-name-and-integrated-security/m-p/90854#M182292 <P>Most of our MS SQL Servers require integrated security and the databases are not on the default instance. Our Splunk servers are all on Linux. I know how to use Java to configure JTDS to connect to these SQL instances using Integrated security, e.g.:</P> <P>java -classpath ./lib/jisql.jar:./lib/jtds-1.2.6.jar com.xigole.util.sql.Jisql -user ...<BR /> ... -cstring "jdbc:jtds:sqlserver://host_name:port_no/db_name;domain=domain_name;instance=instance_name" ....</P> <P>Is there a way to do this in Splunk DB Connect (DBX)?</P> Thu, 11 Apr 2013 16:02:46 GMT reed_kelly 2013-04-11T16:02:46Z https://community.splunk.com/t5/Splunk-Search/DB-Connect-with-instance-name-and-integrated-security/m-p/90854#M182292 <P>Most of our MS SQL Servers require integrated security and the databases are not on the default instance. Our Splunk servers are all on Linux. I know how to use Java to configure JTDS to connect to these SQL instances using Integrated security, e.g.:</P> <P>java -classpath ./lib/jisql.jar:./lib/jtds-1.2.6.jar com.xigole.util.sql.Jisql -user ...<BR /> ... -cstring "jdbc:jtds:sqlserver://host_name:port_no/db_name;domain=domain_name;instance=instance_name" ....</P> <P>Is there a way to do this in Splunk DB Connect (DBX)?</P> Thu, 11 Apr 2013 16:02:46 GMT https://community.splunk.com/t5/Splunk-Search/DB-Connect-with-instance-name-and-integrated-security/m-p/90854#M182292 reed_kelly 2013-04-11T16:02:46Z https://community.splunk.com/t5/Splunk-Search/DB-Connect-with-instance-name-and-integrated-security/m-p/90855#M182293 <P>I found the non-default instance name part: <A href="http://splunk-base.splunk.com/answers/66459/connect-to-a-non-default-instance-of-ms-sql-server">http://splunk-base.splunk.com/answers/66459/connect-to-a-non-default-instance-of-ms-sql-server</A>. The remaining question is whether Integrated security can be used for MS SQL.</P> Thu, 11 Apr 2013 17:39:36 GMT https://community.splunk.com/t5/Splunk-Search/DB-Connect-with-instance-name-and-integrated-security/m-p/90855#M182293 reed_kelly 2013-04-11T17:39:36Z https://community.splunk.com/t5/Splunk-Search/DB-Connect-with-instance-name-and-integrated-security/m-p/90856#M182294 <P>Windows Authentication (NTLMv2) can be enabled by specifying the user in the form of <CODE>DOMAIN\username</CODE>. This will result in a JDBC URL like this:</P> <PRE><CODE>jdbc:jtds:sqlserver://hostname:port/db;domain=DOMAIN;useNTLMv2=true;otherparams=.... </CODE></PRE> <P>In addition, other parameters for the JDBC URL of an MSSQL database connection can be specified in the database.conf stanza by adding <CODE>arg.&lt;paramName&gt;=&lt;value&gt;</CODE>:</P> <PRE><CODE>[mysqlserver] host = ... database = ... username = ... password = ... arg.useNTLMv2 = false arg.socketTimeout = 300 </CODE></PRE> Sat, 13 Apr 2013 10:57:02 GMT https://community.splunk.com/t5/Splunk-Search/DB-Connect-with-instance-name-and-integrated-security/m-p/90856#M182294 ziegfried 2013-04-13T10:57:02Z