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.
have you installed the jTDS driver? http://docs.splunk.com/Documentation/DBX/2.0.6/DeployDBX/Installdatabasedrivers#Microsoft_SQL_Server
jTDS driver is installed, as well as JRE 8.
Sam, maybe we should use DB Connect 1 until someone answers this DB Connect 2 issue.