The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×
Forums
Home Q&A Discussion groups Articles Ask a question Search
Learning
Events
Champions
Release Notes
Community
Forums
Home Q&A Discussion groups Articles Ask a question Search
Learning Events Champions Release Notes
Forums
Home Q&A Discussion groups Articles Ask a question Search
Learning Events Champions Release Notes

Forums

Articles
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

MSSQL Support for atlassian/jira-software docker image

chrisruscio
chrisruscio
November 13, 2019

Is it possible to run the atlassian/jira-software docker container using Microsoft SQL Server without creating a custom dbconfig.xml.j2? 

Looks like the image is hard coded to use the schema "public"[1] which is a reserved keyword in MSSQL[2] and I'm guessing the code doesn't correctly quote references in brackets

[1] https://bitbucket.org/atlassian-docker/docker-atlassian-jira/src/872ee106c71ab2b1cc41929c53b14e5c5d401445/config/dbconfig.xml.j2?at=master#dbconfig.xml.j2-6

[2] https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver15

---

Side note: is it possible to open issues or pull requests directly associated with the docker-atlassian-jira repository? Or is it just public source and not open to public contribution?

Watch
Like Be the first to like this
1859 views

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Answer accepted
Dave Chevell
Dave Chevell
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 19, 2020

Hey @Chris

We ended up fixing this a few days after you originally made this post. It was addressed here: https://bitbucket.org/atlassian-docker/docker-atlassian-jira/pull-requests/32/set-default-db-schema-name-according-to-db/diff

the tl;dr is that we set the correct default for MSSQL ("dbo") and also provided a new environment variable to allow you to override the schema, `ATL_DB_SCHEMA_NAME`

As for pull requests, you can fork the docker-atlassian-jira repository and open a pull request - our team will review any changes and discuss them in the PR.

Cheers,

Dave Chevell  

View More Comments
Faisal Shamim
Faisal Shamim
January 26, 2021

Hello  Team,
This Qs is outof Jira cloud domain , I installed Jira on Docker and try to connect with MS SQL server which is running on Docker too. I Installed SQL server from the following link ,

https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-linux-ver15&pivots=cs1-bash

Can you please help me in knowing exact parameters while setting up database .. I am getting some error while testing connection

Thanks,
Faisal

Like
Faisal Shamim
Faisal Shamim
January 26, 2021

jira docker.PNG

Like
Reply
Jira Service Management
Jira Service Management
TAGS
AUG Leaders

Atlassian Community Events

    See all events
    Community
    Forums
    FAQs Forums guidelines
    Learning
    About learning Resources
    Events
    Champions
    Release Notes
    Copyright © 2026 Atlassian
    Privacy Policy Notice at Collection Terms Security