I am trying to set a new connection in "Splunk DB Connect" (latest version) to a MSSQL server.
i choose connection type ' mssql generic driver and reciving the following error:
Internal server error, originalErrorMessage=No suitable driver found for jdbc:sqlserver://myserver:1433;databaseName=master;selectMethod=cursor
Anybody can help me to set it right?
Make sure you've installed the driver. See http://docs.splunk.com/Documentation/DBX/3.0.3/DeployDBX/ConfigureDBConnectsettings
Thank you, i installed the 4.2 driver version.
Now I'm receiving an error for login failed:
"Internal server error, originalErrorMessage=Login failed for user 'domain\user'. ClientConnectionId: ....."
While this user is working for 'splunk db connect 1'
this is a windows domain user. i assume i need to use the "MSSQL with windows authentication"
while trying to use it, I'm receiving the following:
"Internal server error, originalErrorMessage=This driver is not configured for integrated authentication"
I don't know anything about that error.
Perhaps this answer will help: https://answers.splunk.com/answers/334028/splunk-db-connect-2-why-am-i-getting-this-driver-i.html