Cloudera Community
robert_robakiew
user rank
New Contributor

Re: Nifi connect to sql server kerberos

by New Contributor in Support Questions
‎06-18-2019 09:36 AM
‎06-18-2019 09:36 AM
I also tried from this link: https://medium.com/@danielyahn/nifi-ms-sql-integrated-security-9efc184872db but i still got error: “Cannot create PollableConnectionFactory (cannot login with kerberos principial myuser@mydomain.com, check your credentuials. Kerberos login failed, intergration authentication failed” I tried to conncet to this sql server instance from management studio so it works with credentials i have but somehow i cannot connect from nifi using your tutorial. What could be wrong? ... View more

Re: Nifi connect to sql server kerberos

by New Contributor in Support Questions
‎06-18-2019 09:03 AM
‎06-18-2019 09:03 AM
please of any feedback ... View more

Nifi connect to sql server kerberos

by New Contributor in Support Questions
‎06-17-2019 10:43 AM
‎06-17-2019 10:43 AM
I am trying to connect to sql server by this pooling service url connection according to microsoft docs this should look like this is enough: jdbc:sqlserver://servername=myservername;databasename=somedatabase;integratedSecurity=true;authenticationScheme=JavaKerberos;userName=myuser@wgatever.com;password=somepassword driver type: com.microsoft.sqlserver.jdbc.SQLServerDriver driver lcoation: \otp\mssql\driver in the executeSql proceessor i got following error: Cannot createPollableCOnnectionFactory (TCP/IP connection to the host servername= ... port 1433 has failed. Make sure that instance of sql server is running on the host and accept tcp.ip connection at port .. ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎06-18-2019 09:59 AM
Community Statistics
Member Since ‎06-17-2019 08:33 AM
Last Visited ‎06-18-2019 09:59 AM
Posts 3