Support Questions

Find answers, ask questions, and share your expertise

Nifi connect to sql server kerberos

avatar
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

avatar
New Contributor

please of any feedback

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