#confluence server

In the past 2 years, it has been a real treat using the Atlassian software tools for project and quality management. I recently had the opportunity reinstall the server versions of Jira Software, Bitbucket, and Confluence on another server machine and I thought I’ll just jot down all the steps necessary for future references.

Collaboration tools for teams of all sizes - true dat!

Setting Up the Databases

First up, you need to install Microsoft SQL Server 2014 or later (the free Express edition works too). This is for creating the databases necessary for each software tool to store important data. For simplicity, I will create 3 individual databases (jira, bitbucket, confluence) and 1 admin user (sysadmin).

Log into the Microsoft SQL Server and create the 3 new databases with the following settings.

Enter the database names.

Select the Collation setting under Options. Select case insensitive SQL_Latin1_General_CP437_CI_AI for jira, and case sensitive SQL_Latin1_General_CP1_CS_AS for bitbucket and confluence.

Create a new login.

Select SQL Server authentication and specify the password.

Map the user to the databases created and set its role to db_owner.

Set the READ_COMMITED_SNAPSHOT to ON in all 3 databases.

Fire up the Sql Server Configuration Manager, and set the TCP Port to 1433 for the SQL instance that you created.

Restart the SQL server instance.

Jira Software Server

Proceed to the Atlassian webpage and download the latest installation package for Jira Software Server and launch the installer.

Select Custom Install to go through the settings like file location and shortcut creation.

You could configure the TCP Ports or just use the default values.

Install it as a Service and proceed with the installation.

Launch Jira Software once installation is complete.

Set up JIRA manually to connect with the database created earlier.

Enter the required settings and test connection to database. Proceed to Next if successful.

Setup JIRA site and enter your license key. I recommend setting the base URL to the IP address assigned to the server PC. This way, other PCs in the network can also access the site through the base URL (in my case I disabled the firewall so that other PCs could access the port).

Bitbucket Server and Confluence Server

They pretty much follow the same flow of events as it was in the setting up of JIRA Software Server.

Rounding Up