Splunk DB Connect - setting a MSSQL server

[abovebeyond]

Hi all,

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?
Thanks!

[richgalloway]

Make sure you've installed the driver. See http://docs.splunk.com/Documentation/DBX/3.0.3/DeployDBX/ConfigureDBConnectsettings

[abovebeyond]

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'

Thanks !

[abovebeyond]

an update.
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"

[richgalloway]

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