SQLServer with Kerberos authentication

[Fabien Bergeret]

There are 2 ways for an application to authenticate to SQL Server. The first one, using username/password is well described in the installation process.

The second one, using Kerberos and a keytab file, is not even described.

Is this authentication to DB available on JIRA ? I ask this question because my company policy is to use Kerberos/keytab and not username/password

Regards,

[Gonchik Tsymzhitov]

How about that KB? 

https://confluence.atlassian.com/stashkb/use-integrated-authentication-over-kerberos-when-connecting-to-mssql-on-linux-777021392.html

[KrithVe]

Unfortunately with strong encryption AES256, it does not connect. Krb5.conf, keytab are all generated fine , but connecting to Jira with strong Kerberos encryption is still an issue. 

[KrithVe]

Hi,

I’m able to use keytab with rc4 encryption but not with aes256

keytab generated with rc4, krb5 file updated with rc4. They all connect to Jira fine. They do not connect to dB at all when keytab generated with aes256 and krb5 updated with aes256. I end up with KDC 14 error. 

[Tanmay Shirnalkar]

Hi Fabien, are you able to find any solution on this ? I'm also looking to connect to PostgreSQL DB via Kerberos authentication as Username/Password is not allowed in our org too.

Please let me know if you got any alternative..

[Mathieu GALATRY]

Hi, 

Unfortunately, no technical solution. We had to request our security team for a security exemption :-(

[Tanmay Shirnalkar]

Thanks Fabien for your reply !