According JDBC documentation driver <https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15>, integratedSecurity is a boolean property, and to authenticate against SQLServer you have three options for integratedSecurity=true. Kerberos, NTLM or NativeAuthentication. NativeAuthentication only works in windows os, so you cannot use it in linux.
Juan On Thu, 20 Feb 2020 at 14:49, Pierre Villard <[email protected]> wrote: > 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 >> >>
