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

Question

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?

Nic Brough -Adaptavist- · Answer

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

Alexey Matveev · Answer

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

Yousuf Salem · Answer

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?