Hello, I am a new NIFI user looking for help on MS SQL server AD authentication (using kerberos)
Anyone successfully configured sql server kerberos authentication from NIFI? I tried Nathan Baldie and other posts I found googling, but none of them work. Any pointers or inputs greatly appreciated. Below is my error message from my controller service: Failed to establish Database Connection: java.sql.SQLException: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host servername=<my sql server>, port <my sql server port> has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".) SQL account authentication works fine, so it is not an issue with the sql server, tcpip port or firewall. Below are some articles I followed and I tried without any success. https://nathanlabadie.com/apache-nifi-ms-sql-and-kerberos-authentication/ https://www.exabeam.com/information-security/apache-nifi-sql-server-and-kerberos-authentication/ Thanks in advance [GEICO]<https://www.geico.com/> Phani Bandaruvenkata Principal Engineer I | Technology - Centralized Testing - 9 Enterprise TEST Data management (703) 944-0141 | Sensitivity: General/Internal ==================== This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message.
