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

[Yousuf Salem]

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?

[Alexey Matveev]

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]

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

[Yousuf Salem]

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]

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

[Nic Brough -Adaptavist-]

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

[Lars Olav Velle]

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