Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-66352

Support Active Directory authentication for SQL Server when running on Linux

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • None
    • None
    • 1
    • 6
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      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

              Unassigned Unassigned
              dmcmorris@atlassian.com Douglas McMorris (Inactive)
              Votes:
              6 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated: