Unable to connect to SQL Server 2014 developer version

Kumar Chinnasamy

Hi,

 

I have successfully installed my JIRA and SQL server 2014 on server. It started with embedded databased and worked well.

I want to change the DB to into SQL sever. Hence I changed the dbconf file as mentioned in the Atlassian documentation. But unable to connect and getting error. Please help.

My connection details are below.

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mssql</database-type>
<schema-name>xxxxxxx</schema-name>
<jdbc-datasource>
<url>jdbc:jtds:sqlserver://xxxxxxx:1433/NewDay_JIRA</url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<username>xxxxxxx</username>
<password>xxxxxxx</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
</jdbc-datasource>
</jira-database-config>

But still I am unable to connect and getting error message like ....

Database: JIRA couldn't connect to your database

 

somethingblue

Hi Kumar,

I would follow the instructions in Switching Databases:

1. Create an export of your data as an XML backup. See Backing up data for details.
2. Create a new database on your new database server to house JIRA's data. See the appropriate database configuration guide in the Connecting JIRA to a database section for the database creation instructions.
3. Shut down your JIRA server.
4. Make a backup of your JIRA home directory and JIRA installation directory.
5. Delete the dbconfig.xml file in your JIRA home directory.
6. Restart JIRA and you should see the first step of the JIRA setup wizard for configuring your database connection.
7. Configure JIRA's connection to your new database (created in step 2 above) and click the 'Next' button.
8. On the 'Application Properties' setup page, click the 'import your existing data' link and restore your data from the XML backup created in step 1 above.

Cheers,

Branden