We see following error message on DB Connect 2.0.4 using Java 8 screen while trying to connect to MS SQL Server 2012 R2 using windows user authentication.
com.microsoft.sqlserver.jdbc.SQLServerException:com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '<windows Domain>\HWQ1156$'. ClientConnectionId:f3db99fb-976d-4477-ba05-80b98e5995fa
It seems as if it is unable to get the value for a variable "HWQ1156$" which would be the user with which we are logged on to the Splunk Server. Do we have to pass this value explicitly somewhere on the configuration file as we do not see it documented or asked anywhere within Splunk or DB Connect Documentation?
Can we do this connectivity only if Splunk logon is configured using windows authentication? As our Splunk user logins are local ones. Only while connecting to MS SQL Server from DB Connect we plan to use the windows authentication.
Can someone help me with this error?
"this driver is not configured for integrated authentication"
Realized that we missed following few critical steps required for Windows Authentication which are as follows
After the steps are performed on Splunkd Service for the user we are able to connect to MS SQL Server using a windows authentication user on DB Connect 2.0.4.
Following section has all the required steps under Title "Can't use Windows authentication for Microsoft SQL Server with Microsoft JDBC Driver for SQL Server"