Support Active Directory authentication for SQL Server when running on Linux

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Unresolved
    • None
    • Component/s: None
    • None
    • 1
    • 6

      Problem Definition

      In JIRA 7.5 the JDBC driver was changed from the JTDS driver to the Microsoft SQL Server driver. In JTDS there was a workaround to configure it for Active Directory authentication while running on linux:

      Unfortunately, it looks like the Microsoft JDBC driver does not support domain-based auth when running on Linux:

      This has led to customers with working JDBC configurations not being able to connect the same way after upgrading to JIRA 7.5+

      Suggested Solution

      Continue to support JTDS or work with the MS SQL Server driver project on support for domain-based auth.

      Workaround

      1. Switch to password-based auth (not fun)
      2. Go back to the old JTDS driver (not tested and not supported by Atlassian)
      3. Possibly: implement Kerberos integration as described on Microsoft's documentation

            Assignee:
            Unassigned
            Reporter:
            Douglas McMorris (Inactive)
            Votes:
            6 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated: