Confluence is an Atlassian Java web application for team collaboration and knowledge management. Let’s install it for evaluation on the following server and client environment:
- Windows 7 Professional operating system
- Apache Tomcat application server (bundled with installer)
- MS SQL Server 2008 database server
- Oracle JRE/JDK 1.7
- MS Internet Explorer 8+, Mozilla FireFox , Google Chrome, Safari
1. Setting up an MS SQL Server database for Confluence
We are going to use MS SQL Server 2008 as our external database. So before we lauch the Confluence install wizard, let’s create the database for confluence using the following steps:
- Launch SQL Server Management Studio
- Right click on Databases and select New Database…
Set the default collation for the database to be ‘SQL_Latin1_General_CP1_CS_AS‘ (case sensitive):
Configure the database to use the isolation level, ‘Read Committed with Row Versioning’:
Using your SQL administrator permissions, create a new SQL user account for Confluence (for example, usrConfluence). Give this user full create, read and write permissions for the database tables. Note that Confluence must be able to create its own schema.
Create the new MS SQL User user login for the confluence database:
Now grant confluence user privileges to access the confluence database:
2. Install Atlassian Confluence using the Installation Wizard
- Download the installer. Right click the file and select Run As Administrator to launch the installer wizard
- Next > Custom Install
- Destination directory: c:\atlassian\confluence
- Default location for confluence data: c:\atlassian\data\confluence
- Start Menu Folder > Next
- Configure TCP Ports: Use default ports (HTTP 8090, Control 8000) – Recommended
- Tick: Install Confluence as a Service
- Launch Confluence 5.4.2 in browse. Click Finish.
3. Confluence browser based configurations
In the previous step, you clicked Finish to launch Confluence in the browser. We are almost done. Carry out the following steps to install the licence, connect to the external database, load sample contents, and configure the system account.
- Copy and paste the licence into the licence string box (if you are evaluating, obtain a licence prior to this step from Atlassian)
- Select Production – External database
- In the Configure Database screen, enter the following for the database:
- Load Content: Example Site
- Configure User Management: select Manage user and groups with Confluence
- Configure System Administrator Account
That’s all. You’ve now installed Atlassian Confluence on Windows 7 Professional and connect it to an external MS SQL Server 2008 database.