Can't connect to SQL Server 2008

[Sefa Ümit Oray]

Hello everyone,

I have installed Jira 5.1.3 and i'm using Sql server 2008 express on my computer. I have created a database and configured my sql server just like explained at the documentation.

When i try to open Jira, i'm receiving The requested resource () is not available. error.

What can be wrong? Here is my dbconfig.xml file

Note: I tried already 192.168.1.2, Sefa-PC, . etc instead of 127.0.0.1

<?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>jiras</schema-name>

<jdbc-datasource>

<url>jdbc:jtds:sqlserver://127.0.0.1:1433/jira;instance=SQLEXPRESS</url>

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

<username>jirauser</username>

<password>password123</password>

<pool-min-size>20</pool-min-size>

<pool-max-size>20</pool-max-size>

<pool-max-wait>30000</pool-max-wait>

<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>

[Harry Chan]

Hi, have you followed the setup guide here - https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+SQL+Server+2008? It seems like you are running into permission problems.

Note that as per the supported platforms for JIRA here - https://confluence.atlassian.com/display/JIRA/Supported+Platforms, Express editions are not supported.