How does one connect to using windows authentication and Generic MSSQL driver? We do not want to use the JTDS driver.
It appears that DB Connect 2 is not sending windows authentication credentials to Microsoft SQL Server. This used to work in DB Connect 1.
The dbx log mentions the following error:
dbx8302:INFO:BridgeSession - Caught Exit exception: JavaBridgeExitException{status=1}
dbx2005:ERROR:DatabaseInfoCommand - Error while executing command: Error getting database connection: Network error IOException: Connection reset
See the following solution which has been tested for 2.0.4 and 2.0.5:
Can't use Windows authentication for Microsoft SQL Server with Microsoft JDBC Driver for SQL Server
http://docs.splunk.com/Documentation/DBX/2.0.5/DeployDBX/Troubleshooting
See the following solution which has been tested for 2.0.4 and 2.0.5:
Can't use Windows authentication for Microsoft SQL Server with Microsoft JDBC Driver for SQL Server
http://docs.splunk.com/Documentation/DBX/2.0.5/DeployDBX/Troubleshooting