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?
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.
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?
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:
Cheers, and happy new year!
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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!
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