Installation and integration of Jira and confluence (2)

1. Install Ms sqlserver2000 database. Remember to install Ms sqlserver2000 service pack4;
1.1 to customize the installation process, select the chinese_rpc sorting method. The language is simple Chinese;
1.2 select hybrid mode for identity authentication;

2.Then create jiradb and jirauser. During the creation of jirauser, you must first create a login name, jirauser. Assign the public and db_owner roles to jirauser. Do not use jirauser as the database owner;

3. edit CONF/server. XML file ...... /> content, modified to:
Jira " reloadable = "false">
username =" jirauser "
Password =" 123456 "
driverclassname =" net. sourceForge. jtds. JDBC. driver "
url =" JDBC: jtds: sqlserver : // localhost: 1433/jiradb "/>

4.Edit Atlassian-JIRA/WEB-INF/classes/entityengine. xml file, modify the attribute value of field-type-name to MSSQL (field-type-name = "MSSQL ");

5.Download connection MsSqlserverThe JDBC driver of the database, jtds (http://jtds.sourceforge.net/) is recommendedJtds-[version]. JarCopy the file to the common \ lib directory;
Modify the memory configuration: HKEY_LOCAL_MACHINE \ SOFTWARE \ Apache Software Foundation \ procrun2.0
6.Run startup. bat in the bin directory to startJIRA;

7.Access through the browser address http: // localhost: 8080/JIRA, According to the wizard ConfigurationJIRA.