Hi All,
I have installed Splunk DB Connect 2 and am trying to connect to my SQL Server database. Both Splunk and SQL Server are running on my local machine. I followed the DB Connect 2 instructions and am trying to use the Windows Authentication process.
I have created an Identity and Connection, but when I validate the connection, I get the "Internal Server Error" message. I can read the log in Splunk by running the code index=_internal source=*dbx2.log and I get this message:
Validating connection with URL [jdbc:sqlserver://localhost:1433;databaseName=northwind;selectMethod=cursor;integratedSecurity=true] failed: java.sql.SQLException:java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.
I am not sure what this means as I am certain I followed the steps to install the correct library so that it will use integrated authentication.
Any thoughts would be appreciated.
... View more