The steps to make NBT Agent use Integrated Authentication on Windows are:


  • Change de jdbc connection string in the Config Sources screen for the Campaing. You must add the property integratedSecurity on it. 

Example: jdbc:sqlserver://localhost;databaseName=myDatabaseName;integratedSecurity=true;

  • Copy the file sqljdbc_auth.dll file to the NBT Agent folder. 

Notes:

  • The sqljdbc_auth.dll files are installed in the following location: <installation directory>\sqljdbc_<version>\<language>\auth\

  • If you are running a 32-bit Java Virtual Machine (JVM), use the sqljdbc_auth.dll file in the x86 folder, even if the operating system is the x64 version. If you are running a 64-bit JVM on a x64 processor, use the sqljdbc_auth.dll file in the x64 folder.