Splunk DB Connect 2: Why am I getting Internal Server Error trying to connect to MS SQL Server 2012?

[samtawfik]

Having an issue connecting to MS SQL server 2012 (local). Error : "⚠ Internal Server Error"

Here is my db_connections.conf file modified:

[splunkcn]
connection_type = mssql
database = ZiteDB
host = CAWCDELL158\SQLEXPRESS
identity = splunkDB
jdbcUseSSL = 0
jdbcUrlFormat = jdbc:jtds:sqlserver://<host>:<port>/<database>;useCursors=true;domain=<domain_name>;useNTLMv2=true
domain_name = MSSQLSERVER12
disabled = 0
port = 50375

Here is my DB Connect V2 configuration: No issue on my identities screen.

App: Splunk DB Connect v2
Host: CAWCDELL158\SQLEXPRESS
Database Types: MS SQL Server Using jTDS driver
Default Database: ZiteDB
Identity: splunkDB
Port: 50375

I am suspecting the issue is in the conf file, specific to the Domain Name.
Thanks in advance.

[jcoates_splunk]

have you installed the jTDS driver? http://docs.splunk.com/Documentation/DBX/2.0.6/DeployDBX/Installdatabasedrivers#Microsoft_SQL_Server

[samtawfik]

jTDS driver is installed, as well as JRE 8.

[youngc_splunk]

Sam, maybe we should use DB Connect 1 until someone answers this DB Connect 2 issue.