You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@nifi.apache.org by Samarendra Sahoo <sa...@gmail.com> on 2020/02/19 17:57:43 UTC
Execute SQL to MSFT SQLServer - getting error
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
Re: FW: Execute SQL to MSFT SQLServer - getting error
Posted by Samarendra Sahoo <sa...@gmail.com>.
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 <pi...@gmail.com>
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 <
> sahoo.samarendra@gmail.com> 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* <pi...@gmail.com>
>> Date: Thu, 20 Feb, 2020, 12:54 AM
>> Subject: Re: Execute SQL to MSFT SQLServer - getting error
>> To: <us...@nifi.apache.org>
>> Cc: <de...@nifi.apache.org>
>>
>>
>>
>> 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 <
>> sahoo.samarendra@gmail.com> 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
>>
>>
Re: FW: Execute SQL to MSFT SQLServer - getting error
Posted by Juan Pablo Gardella <ga...@gmail.com>.
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 <pi...@gmail.com>
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 <
> sahoo.samarendra@gmail.com> 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* <pi...@gmail.com>
>> Date: Thu, 20 Feb, 2020, 12:54 AM
>> Subject: Re: Execute SQL to MSFT SQLServer - getting error
>> To: <us...@nifi.apache.org>
>> Cc: <de...@nifi.apache.org>
>>
>>
>>
>> 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 <
>> sahoo.samarendra@gmail.com> 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
>>
>>
Re: FW: Execute SQL to MSFT SQLServer - getting error
Posted by Juan Pablo Gardella <ga...@gmail.com>.
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 <pi...@gmail.com>
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 <
> sahoo.samarendra@gmail.com> 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* <pi...@gmail.com>
>> Date: Thu, 20 Feb, 2020, 12:54 AM
>> Subject: Re: Execute SQL to MSFT SQLServer - getting error
>> To: <us...@nifi.apache.org>
>> Cc: <de...@nifi.apache.org>
>>
>>
>>
>> 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 <
>> sahoo.samarendra@gmail.com> 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
>>
>>
Re: FW: Execute SQL to MSFT SQLServer - getting error
Posted by Samarendra Sahoo <sa...@gmail.com>.
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 <pi...@gmail.com>
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 <
> sahoo.samarendra@gmail.com> 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* <pi...@gmail.com>
>> Date: Thu, 20 Feb, 2020, 12:54 AM
>> Subject: Re: Execute SQL to MSFT SQLServer - getting error
>> To: <us...@nifi.apache.org>
>> Cc: <de...@nifi.apache.org>
>>
>>
>>
>> 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 <
>> sahoo.samarendra@gmail.com> 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
>>
>>
Re: FW: Execute SQL to MSFT SQLServer - getting error
Posted by Pierre Villard <pi...@gmail.com>.
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 <sa...@gmail.com>
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* <pi...@gmail.com>
> Date: Thu, 20 Feb, 2020, 12:54 AM
> Subject: Re: Execute SQL to MSFT SQLServer - getting error
> To: <us...@nifi.apache.org>
> Cc: <de...@nifi.apache.org>
>
>
>
> 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 <
> sahoo.samarendra@gmail.com> 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
>
>
Re: FW: Execute SQL to MSFT SQLServer - getting error
Posted by Pierre Villard <pi...@gmail.com>.
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 <sa...@gmail.com>
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* <pi...@gmail.com>
> Date: Thu, 20 Feb, 2020, 12:54 AM
> Subject: Re: Execute SQL to MSFT SQLServer - getting error
> To: <us...@nifi.apache.org>
> Cc: <de...@nifi.apache.org>
>
>
>
> 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 <
> sahoo.samarendra@gmail.com> 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
>
>
Fwd: FW: Execute SQL to MSFT SQLServer - getting error
Posted by Samarendra Sahoo <sa...@gmail.com>.
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* <pi...@gmail.com>
Date: Thu, 20 Feb, 2020, 12:54 AM
Subject: Re: Execute SQL to MSFT SQLServer - getting error
To: <us...@nifi.apache.org>
Cc: <de...@nifi.apache.org>
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 <sa...@gmail.com>
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
Fwd: FW: Execute SQL to MSFT SQLServer - getting error
Posted by Samarendra Sahoo <sa...@gmail.com>.
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* <pi...@gmail.com>
Date: Thu, 20 Feb, 2020, 12:54 AM
Subject: Re: Execute SQL to MSFT SQLServer - getting error
To: <us...@nifi.apache.org>
Cc: <de...@nifi.apache.org>
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 <sa...@gmail.com>
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
Re: Execute SQL to MSFT SQLServer - getting error
Posted by Pierre Villard <pi...@gmail.com>.
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 <sa...@gmail.com>
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
>
>
Re: Execute SQL to MSFT SQLServer - getting error
Posted by Pierre Villard <pi...@gmail.com>.
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 <sa...@gmail.com>
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
>
>