can Jira and Confluence share a Microsoft SQL server?

hi all,

I am about to setup a JIRA VM and Confluence VM along with Microsoft SQL 2014 DB server/s.  Do I need to have a DB server for each or can I get away with sharing 1 DB server but have 2 DB's on it?  Thanks!

2 answers

1 accepted

You can have 1 SQL Server and have 2 DB's on it... one for JIRA and one for Confluence.  That is how we have been running it and I would assume most are.  

One thing to note is I am not aware, as of today, of any current JIRA version that officially supports SQL Server 2014.  I think the latest it supports is SQL Server 2012. 

Cool thanks for the information.  Thankfully our SQL license allows us to use 2012 instead, so if JIRA doesn't in fact support 2014 then i will just use 2012.  Cant imagine much of a difference between the two that would effect JIRA or confluence performance.  Thanks again!

No problem.  Just an FYI Atlassian announced that first Q1 2016 they will support SQL Server 2014 for Jira.  I think they already support it for the latest Confluence.

Oh that's good to know!  It might be worth waiting a little longer then.

Thanks!!

Ahmad,

I am not a pro with SQL so I have to ask this question.  I am setting up JIRA, I already have Confluence working, but JIRA will not connect to the DB that i setup on the server.  I keep getting the following error in JIRA

Error connecting to database

Network error IOException: Connection refused: connect

Connection refused: connect

any ideas?

 

thanks!

nm found my answer! smile thanks!

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Amir Kazemi
Posted 3 hours ago in Jira

We want to know what Jira Service Desk apps you're using!

Hi Community! My name is Amir and I’m on the Jira Service Desk product marketing team at Atlassian. Our team would love to understand how you’re leveraging our ecosystem for Jira Service Desk. Wha...

14 views 0 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you