Configure Active Directory authentication for SQL Server in Jira server

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Fisheye および Crucible は除く

This KB article was originally created for older Jira versions.   Starting with Jira 7.5.0 and higher, Atlassian switched the database driver being used by Jira upon installation/upgrade to use the official Microsoft database driver when connecting to a Microsoft SQL database.  As such Jira is not using the jTDS open source driver it was using in versions such as 7.4.x and previous versions, when this article was created.

As such the steps in this article will not work with Jira 7.5.0 and higher.   Instead there is a different KB for how to allow Jira to use that database driver to authenticate to a SQL server in Using Integrated Security with MsSQL for Jira

This feature has not been tested by our QA team and, therefore, its usage is still unsupported. A Suggestion has been raised in order to have this feature tested and considered officially supported, since it's fully supported by the jTDS driver.

Atlassian Support reserves its rights to ask users to rollback this configuration in order to troubleshoot database connection or other related problems.

Depending on the authentication method used by your company, you may need to setup the SQL Server database using an Active Directory credential. Jira doesn't currently support it by default, so you will need to manually change database settings on the dbconfig.xml file.

Follow the procedures indicated below to make possible for Jira to connect with the database using an Active Directory credential.

Special thanks to our customer, William, who provided the workaround here.

ソリューション

  1. Open up the dbconfig.xml file.

    The file is located in your <JIRA_HOME> directory.

  2. Update the <url> key to contain the domainName property

    <url>
    	jdbc:jtds:sqlserver://serverName:port/databaseName;autoCommit=false;useNTLMv2=true;domain=domainName
    </url>

    You may need to add the useNTLMv2=true property depending on your environment configuration.

説明 This article describes steps for Jira to connect with the database using an Active Directory credential.

最終更新日 2020 年 7 月 23 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.