Install Confluence on Windows 7 with MS SQL Server 2008


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…

    Database name: confluence
    Click Add

Set the default collation for the database to be ‘SQL_Latin1_General_CP1_CS_AS‘ (case sensitive):

ALTER DATABASE confluence COLLATE SQL_Latin1_General_CP1_CS_AS

Configure the database to use the isolation level, ‘Read Committed with Row Versioning’:

SELECT is_read_committed_snapshot_on FROM   sys.databases WHERE name=’confluence’

ALTER DATABASE confluence
SET READ_COMMITTED_SNAPSHOT ON
WITH ROLLBACK IMMEDIATE;

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:

Security > Logins
Right click and select New Login…
Login name: usrConfluence
SQL Server authentication
Password: mypassword

Uncheck User must change password at next login
Default database: confluence
Default language: English

Now grant confluence user privileges to access the confluence database:

Databases > confluence > Security > Users
Right click and select New user…
User name: usrConfluence
Login name: Browse to find and select usrConfluence
Default schema: dbo
Role Members:
db_datareader
db_datawriter
db_ddladmin
db_owner

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
  • Install
  • Launch Confluence 5.4.2 in browse. Click Finish.

confluence-1 confluence-6 confluence-7 confluence-8

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:

    Driver Class Name: net.sourceforge.jtds.jdbc.Driver
    Database URL: jdbc:jtds:sqlserver://localhost:1433/confluence
    User Name: usrConfluence
    Password: <the password you enter for usrConfluence>

  • Load Content: Example Site
  • Configure User Management: select Manage user and groups with Confluence
  • Configure System Administrator Account

    Username: admin
    Name: Confluence Admin
    Email: <confluence-admin-email>
    Password: <password for confluence-admin>

confluence-10a confluence-11 confluence-12 confluence-13

That’s all. You’ve now installed Atlassian Confluence on Windows 7 Professional and connect it to an external MS SQL Server 2008 database.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s