Install Jira on Windows Server and MS-SQL

Step 1: Create a Service Account

1. Log on to DC (If ADUC not locally available)
2. Launch Active Directory Users and Computers
3. Expand the forest to reveal the Service Accounts node
4. Right Click the node and select New > User
5. Complete the new object wizard (First Name: Jira, Last Name: Service, Logon name: srv_jira) – Next
6. Specify a secure password and confirm. Set the account to not require a change, and never expires. – Next

   

7. Click Finish

Step 2 Create a SQL Database

1. Logon to SQL Server
2. Open SQL Server Management Studio and Login
3. Expand the Instance
4. Expand Databases OU/Folder
5. Right Click the Databases OU and Click New Database
6. Give the Database a Name

   

7. Click the Options Tab
8. From the Collation Dropown, Select SQL_Latin1_General_CI_AI or SQL_Latin1_General_CP437_CI_AI
9. Click OK

Step 3: Give SRV Account Permissions to Database

1. In SQL Management Studio, go to the Security OU/Folder and right click
2. Select New > Login
3. Click Search
4. Click Locations
5. Select the relevant domain and click OK

   

6. Enter the name of your service account in the Enter the object name to select field and click Check Names

   

7. Select User Mapping from the Right hand pane.
8. In the Users mapped to this login pane scroll to the database created in stage 2 and put a tick in the tick box.
9. With the Jira Database still selected, In the Database role membership pane select:
   – Public
   – db_datareader
   – db_datawriter
   – db_owner

   

10. Click OK

Step 4: Install Jira

1. Logon to the Application Server where Jira is to be installed
2. Download the Jira Installation EXE to the server
3. Launch the Application Install EXE

   

4. Click Next
5. Select Custom Install (recommended for advanced users) – Click Next
6. Specify an Installation Directory (Default is fine) – Click Next
7. Specify Attachments Directory (Default is fine) – Click Next
8. Check the Start Menu folder name – Click Next
9. Select Use Default Ports (we will secure using TMG Later) – Click Next
10. Tick the Install JIRA as a Service box – Click Next
11. Review the settings and if correct – click Install

    

12. Leave the Launch Jira Software in Browser option selected and click Finish

Step 5: Pair your Jira Instance with the Database

1. When the web browser has loaded, select I’ll set it up myself
2. Click Next
3. Select the Built In radio button (we will associate the MsSQL Later) – Click Next
4. Close the Browser
5. Launch the Services.msc and stop Atlassian JIRA Service
6. Launch Notepad as an Administrator
7. Navigate to C:\Program Files\Atlassian\Application Data\JIRA\
8. Open the dbconfig.xml
9. Make the following changes:<database-type>h2</database-type>
   to
   <database-type>mssql</database-type>

   <schema-name>PUBLIC</schema-name>
   to
   <schema-name>dbo</schema-name>

   <url>jdbc:h2:file:C:\Program Files\Atlassian\Application Data\JIRA/database/h2db</url>
   to
   <url>jdbc:jtds:sqlserver://[SQLServerFQDN]:1433/[DBName];domain=[Domain]</url>

   <driver-class>org.h2.Driver</driver-class>
   to
   <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

   <username>sa</username>
   to
   <username>[DomainAccount]</username>
   (Note: No Domain is specified here!)

   <password></password>
   to
   <password>[domain account password]</password>

   

10. Save changes
11. Close config file
12. Start the Atlassian JIRA Service
13. Go to the Log Directory for the installation (Program files/Atlassian/Application Data/Jira/log)
14. Open atlassian-jira.log and ensure the service started and connected to the Database successfully

Step 6: Configure your Jira System

1. From the Start Menu select Access Jira
2. Set the Application title: MindLink Jira
3. Set the Mode to Private
4. Set the base URL to the required address address you will use to access Jira
5. Click Next

   

6. Provide License Key and Click Next
7. Specify the Jira Admin Credentials you wish to use and click Next
8. Select the option to set up Email Notifications Now
9. Specify the SMTP Settings and Click Test Connection
10. When successfully connected – Click Finish
11. Select English (United Kindom) [Default] – Click Continue
12. Click Next to bypass Avatar selection
13. Click Skip quick tour
14. Create Projects as requires (this can be bypassed and created later if you like)

You’re done! You now have a configured functional Jira!