Can I install JIRA & Confluence on same server using same database? (For SSO)

I have successfully installed JIRA 7.6.2 on port 8080 using SQL Server 2012 as the database.

I now want to install Confluence 6.4.1 on the same server, using the same database credentials. Is it possible to have both on same or will it result in some errors?

I want to use same because the users accessing both the apps are going to be same, so it would be single sign-on for them. Right?

2 answers

1 vote


There are different terminology for databases. For example, you store jira and confluence objects in schemes for Oracle and in databases for  SQL Server and Postgres. That is why you can not store jira and confluence objects in the same scheme for oracle and in the same database for SQL Server and Postgres.

But actually it has nothing to do with users who access jira and confluence. If you have same users then you could store all users in a ldap and connect jira and confluence to the ldap. Or you can use Jira user directory. In this case Confluence will see all users from Jira internal directory.

Do not think about databases.

And if you want SSO then you have to decide which provider you are going to use for SSO, setup this provider and install an addon to Jira which can work with the provider.

Again it has nothing to do with the database

Thanks @Alexey Matveev [cPrime] & @Lars Olav Velle, but as I understand from the below 2 links, the database collations are different for JIRA and Confluence:

Connecting JIRA to SQL Server:

And this for Confluence:

As I proceed to install Confluence, it asks for setting up the database. So are you saying, I should not provide same database name? I was thinking of using the same database name and credentials, so that automatically same users will be available for confluence and I can just enable confluence license for selected users. Am I missing something here?

You should not provide the same database name. It does not work like that.

Install Jira and Confluence in different databases. Then choose SSO provider and cofigure it. Or use Jira user directory as the user provider for Confluence

Putting a Jira and Confluence database in the same space will corrupt both of them irretrievably.  They must have separate database areas.

Hello @Yousuf Salem

You can install JIRA and Confluence on the same server, but as @Alexey Matveev [cPrime] points out, this has nothing to do with SSO.


Depending on where your users reside (Active Directory, Azure, Google  etc.) you can connect JIRA/Confluence to that directory by adding a user directory and you´ll have all your users inside both applications.

That means that users use the same username and password on both applications.

Once that is set up, then you can install a plugin that will give you SSO. 

I work for Kantega Single Sign-on and we support both Kerberos and SAML SSO:


Cheers, and happy new year!


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

1,116 views 59 8
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