Thanks a lot Pierre. We checked the link and find configurations are same as per that. The MS SQL server is installed on windows server and we suspect it could be because of SSPI Authentication. Link below has details.
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-syntax <https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdotnet%2Fframework%2Fdata%2Fadonet%2Fconnection-string-syntax&data=02%7C01%7CSamarendra_sahoo%40infosys.com%7C35dafbabbfb84e629b3608d7b93dedbe%7C63ce7d592f3e42cda8ccbe764cff5eb6%7C1%7C0%7C637181547934535428&sdata=PnlzNZVPBVjF%2FhYig7YymbwBj3zmkVZSOWk%2BWxysvHo%3D&reserved=0> https://en.wikipedia.org/wiki/Security_Support_Provider_Interface#Windows_SSPs <https://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FSecurity_Support_Provider_Interface%23Windows_SSPs&data=02%7C01%7CSamarendra_sahoo%40infosys.com%7C35dafbabbfb84e629b3608d7b93dedbe%7C63ce7d592f3e42cda8ccbe764cff5eb6%7C1%7C0%7C637181547934545428&sdata=nvU6fTmLP3fo%2FGc6wKdInjvCagE0v7Wg5Gw9b7DEk6c%3D&reserved=0> Could you pls suggest - how should we configure nifi in the below cases of auth mechanism? 1. Integrated Security=SSPI *- *using NTLM for SSPI 2. Integrated Security=true On Thu, Feb 20, 2020 at 11:19 PM 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 >> >>
