title: Apache NiFi with MS SQL Server integration
body: <p>I'm about to connect <a href="https://nifi.apache.org" rel="nofollow noreferrer">ApacheNiFi</a> to the MS SQL Server as bellow:</p>
  
  <pre><code>1) ApacheNiFi is deployed on Ubuntu 18.04 server
  
  2) ExecuteSQL 1.9.0 processor is using Database Connection Pooling Service 
  </code></pre>
  
  <hr>
  
  <pre><code>3) DBCPConnectionPool 1.9.0 is using JTDS driver to connect MS SQL Server
     Database Connection URL=
     [
       jdbc:jtds:sqlserver://10.10.10.1:1433;
       databaseName=MY_DB; 
       domain=MY_DOMAIN;
       authenticationScheme=JavaKerberos;
       trustServerCertificate=true;
       authentication=NotSpecified;useNTLMv2=true
     ]
  
  4) Database Driver Class Name=[net.sourceforge.jtds.jdbc.Driver]
  5) Database Driver Location(s) = [file:///opt/install/nifi-1.9.0/lib/jtds-1.3.1.jar]
  6) Database User = [myuser@MY_DOMAIN]
  7) Password = [*****]
  </code></pre>
  
  <hr>
  
  <pre><code> 8) Authorization is done on Active Directory located in SERVERS_DOMAIN
  
   9) I can logon server from my Excell/Access with no issue.
  10) However my NiFi is getting response back
      [
         Caused by: java.sql.SQLException: Login failed. The login is from an untrusted 
         domain and cannot be used with Windows authentication 
         atnet.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
      ]
  </code></pre>
  
  <p>Please advise how such issue can be resolved.</p>