Thanks a lot Peter. Attaching the controller. In addition to the controller setting, adding jdbc 8 driver, we have added mssql-jdbc_auth dll at below locations in the Nifi server.
/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.141-3.b16.el6_9.x86_64/bin/mssql-jdbc_auth-8.2.0.x64.dll /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.141-3.b16.el6_9.x86_64/jre/bin/mssql-jdbc_auth-8.2.0.x64.dll --------- Forwarded message --------- From: *Pierre Villard* <[email protected]> Date: Thu, 20 Feb, 2020, 12:54 AM Subject: Re: Execute SQL to MSFT SQLServer - getting error To: <[email protected]> Cc: <[email protected]> Hi, Based on the error, it sounds like the driver you are using is not configured for integrated authentication. Can you share more details about how you configured your controller service? Thanks, Pierre Le mer. 19 févr. 2020 à 09:58, Samarendra Sahoo <[email protected]> a écrit : Dear all, We are trying to connect to SQLServer from Nifi installed on a RHEL Linux VM. We are not able to find a way to connect SQLServer configured with Integrated Security=*SSPI *with Windows login Authentication* ( Note : Kerberos not enabled ) *. We are trying to use *DBCPConnectionPool *with JDBC database connector *jdbc:sqlserver://xx.xxx.xx.xxx:port;databaseName=DEMODB;integratedSecurity=SSPI . *However its not allowed us to login to SQLServer. Does nifi provide any connector/Component or to connect to SSPI Security mode ? Or Is there any other way to connect using custom code connector? Attaching error message for reference
