Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Nifi connect to sql server kerberos

New Contributor

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;authentic...


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

2 REPLIES 2

New Contributor

please of any feedback

New Contributor

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?

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.