Looks like an issue with your driver, according to: https://blogs.msdn.microsoft.com/jdbcteam/2007/06/18/com-microsoft-sqlserver-jdbc-sqlserverexception-this-driver-is-not-configured-for-integrated-authentication/ <https://blogs.msdn.microsoft.com/jdbcteam/2007/06/18/com-microsoft-sqlserver-jdbc-sqlserverexception-this-driver-is-not-configured-for-integrated-authentication/>
cheers, --alex > On May 24, 2016, at 1:35 PM, Ravisankar Mani <[email protected]> wrote: > > Hi Pierre, > > Thank you for the update, > > Please find the below logs. > > > 2016-05-24 02:25:50,530 ERROR [Timer-Driven Process Thread-2] > o.apache.nifi.processors.standard.PutSQL > org.apache.nifi.processor.exception.ProcessException: > org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (This driver is not configured for integrated > authentication.) > at > org.apache.nifi.dbcp.DBCPConnectionPool.getConnection(DBCPConnectionPool.java:225) > ~[na:na] > at sun.reflect.GeneratedMethodAccessor338.invoke(Unknown Source) ~[na:na] > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > ~[na:1.7.0_51] > at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_51] > at > org.apache.nifi.controller.service.StandardControllerServiceProvider$1.invoke(StandardControllerServiceProvider.java:164) > ~[nifi-framework-core-0.6.0.jar:0.6.0] > at com.sun.proxy.$Proxy89.getConnection(Unknown Source) ~[na:na] > at org.apache.nifi.processors.standard.PutSQL.onTrigger(PutSQL.java:205) > ~[na:na] > at > org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:27) > ~[nifi-api-0.6.0.jar:0.6.0] > at > org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1057) > [nifi-framework-core-0.6.0.jar:0.6.0] > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:136) > [nifi-framework-core-0.6.0.jar:0.6.0] > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47) > [nifi-framework-core-0.6.0.jar:0.6.0] > at > org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:123) > [nifi-framework-core-0.6.0.jar:0.6.0] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > [na:1.7.0_51] > at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304) > [na:1.7.0_51] > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) > [na:1.7.0_51] > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) > [na:1.7.0_51] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_51] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_51] > at java.lang.Thread.run(Thread.java:744) [na:1.7.0_51] > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (This driver is not configured for integrated > authentication.) > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) > ~[na:na] > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) > ~[na:na] > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) > ~[na:na] > at > org.apache.nifi.dbcp.DBCPConnectionPool.getConnection(DBCPConnectionPool.java:222) > ~[na:na] > ... 18 common frames omitted > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is > not configured for integrated authentication. > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1352) > ~[sqljdbc4-3.0.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2329) > ~[sqljdbc4-3.0.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905) > ~[sqljdbc4-3.0.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41) > ~[sqljdbc4-3.0.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893) > ~[sqljdbc4-3.0.jar:na] > at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874) > ~[sqljdbc4-3.0.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400) > ~[sqljdbc4-3.0.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045) > ~[sqljdbc4-3.0.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817) > ~[sqljdbc4-3.0.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700) > ~[sqljdbc4-3.0.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842) > ~[sqljdbc4-3.0.jar:na] > at > org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) > ~[na:na] > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) > ~[na:na] > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) > ~[na:na] > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) > ~[na:na] > ... 21 common frames omitted > Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in > java.library.path > at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1886) ~[na:1.7.0_51] > at java.lang.Runtime.loadLibrary0(Runtime.java:849) ~[na:1.7.0_51] > at java.lang.System.loadLibrary(System.java:1088) ~[na:1.7.0_51] > at > com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:32) > ~[sqljdbc4-3.0.jar:na] > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1902) > ~[sqljdbc4-3.0.jar:na] > ... 33 common frames omitted > > > Regards, > Ravi > > On Tue, May 24, 2016 at 7:09 AM, Pierre Villard <[email protected] > <mailto:[email protected]>> wrote: > Hi Ravisankar, > > Could you provide full exception stack trace from the log files in NiFi? > > Thanks, > Pierre > > 2016-05-24 13:05 GMT+02:00 Ravisankar Mani <[email protected] > <mailto:[email protected]>>: > Hi All, > > I have trying to move data to sql server using "PutSQL" processor, In this > case i have created a specific DBCP connection pool. I have tried some > following steps for this operation > > 1. I moved to the "sqljdbc" jar file to nifi lib location and then restart > server. > 2. I can able to moved the data to SQL Server using server authentication. > 3. After i tried to move the data using sql server using windows > authentication, so i have changed my connection string like > jdbc:sqlserver://localhost;database=MyData;integratedSecurity=true; > > In this case i have found some exceptions like > " the driver is not configured for integrated authentication" > > and also i have tried to put "sqljdbc_auth.dll" to nifi lib location. still > the problem not yet solved. Can ypu please share the information for > resolving this issue. > > > Regards, > Ravi > > > > > >
