Based on this thread [1], it looks like it's because the DLL are not loaded by Java. I'd double check what you set for java.library.path system property.
[1] https://stackoverflow.com/questions/6087819/jdbc-sqlserverexception-this-driver-is-not-configured-for-integrated-authentic Le jeu. 20 févr. 2020 à 02:03, Samarendra Sahoo <[email protected]> a écrit : > 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 > >
