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

This widget could not be displayed.
Alexey Matveev Community Champion Jan 01, 2018

Hello,

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.

Alexey Matveev Community Champion Jan 01, 2018

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 & @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: https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2014-938846861.html

And this for Confluence: https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html


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?

Alexey Matveev Community Champion Jan 01, 2018

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.

This widget could not be displayed.

Hello @Yousuf Salem

You can install JIRA and Confluence on the same server, but as @Alexey Matveev 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:

https://marketplace.atlassian.com/search?query=kantega

 

Cheers, and happy new year!

-Lars

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

133 views 1 4
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