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 > >
