- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Nifi connect to sql server kerberos
- Labels:
-
Apache NiFi
Created ‎06-17-2019 10:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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 ..
Created ‎06-18-2019 09:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
please of any feedback
Created ‎06-18-2019 09:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
