Section |
---|
Column |
---|
| Panel |
---|
On this page: Table of Contents |
---|
maxLevel | 4 |
---|
minLevel | 1 |
---|
maxLevel | 4 |
---|
|
|
|
|
Anchor |
---|
| createandconfiguredb |
---|
| createandconfiguredb |
---|
|
...
The JIRA Configuration Tool is only available with JIRA Standalone.
Include Page |
---|
| __database_configurator |
---|
nopanel | true |
---|
| __database_configurator |
---|
|
To connect JIRA to SQL Server 2008 using the JIRA Configuration Tool:...
4.2 Connecting JIRA to SQL Server 2008 Manually
Edit the dbconfig.xml
file at the root of your JIRA Home Directory.
If this file does not exist, create the file, copy and paste the example XML code below into this file and edit the pasted XML as required.
Note |
---|
|
Ensure that the <database-type/> element's content specifies your type of database, as shown below. Also ensure that the <schema-name/> element's content matches the name of the SQL Server's schema specified when creating your JIRA database (above). If you have a named SQL Server instance, your <url/> element's content may look similar to — jdbc:jtds:sqlserver://dbserver:1433/jiradb;instanceinstanceName=instance_name |
When editing your dbconfig.xml
file, escape any '&
' characters by adding 'amp;
' to the end of each one.
Code Block |
---|
|
<?xml version="1.0" encoding="UTF-8"?>
<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>jiraschema</schema-name>
<jdbc-datasource>
<url>jdbc:jtds:sqlserver://dbserver:1433/jiradb</url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<username>jiradbuser</username>
<password>[enter db password]</password>
<pool-size>15</pool-size>
</jdbc-datasource>
</jira-database-config>
|
- Save your edited
dbconfig.xml
file (at the root of your JIRA Home Directory).
JIRA must be restarted for your new settings to take effect.
...