When launching Subset either through Datamaker or as a separate component and connecting to my database connection profile, I am receiving the following error message: 'Login failed for user X'.
"This driver is not configured for integrated authentication"
MS SQL Server is configured for Integrated Authentication.
There are two most likely causes for this error message.
1. The sqljdbc_auth.dll file is missing from your C:\Program Files (x86)\Grid-Tools\GTDatamaker folder.
2. You are are adding a username and password in your Subset connection profile.
If you are using Subset with a MS SQL Server (MSSQL) Database that has been configured only for Windows Authentication, but not for SQL Server Authentication, then you will experience this error.
The steps below will enable you to connect to and use data that resides in a MS SQL Server DB (MSSQL DB), that allows only Windows (Integrated) authentication.