Connect JIRA to SQL Server 2008 fails

I'm trying to connect Jira to external database. The main goal is to connect to Jira's database from Visual Studio.

When I finish the whole sequence of steps in the JIRA walkthrough ( ) I get this message in my browser window:

Oops - an error has occurred
System Error
Cause: java.lang.NullPointerException .

After that there are stack trace, build info, server info, etc. (full report is on my goo-docs: )

I've searched in google, but didn't find anything relevant.

Also I've tried to connect Jira to MySQL 5.5, and tried to do it on another machine (with win 7), with the very same result. Here is the process i'm following:
create db "jiradb" in SQL Server Management Studio
create login "jiradbuser", disable password policy, set default db to "jiradb", set user mappings as it is in documentation: jiradbuser has roles: public, db_owner
Enable tcp/ip on server
set mixed auth on server
configure Jira with Jira Configuration Tool, test connection (successful).

Also I've installed new Jira copy and set SQL Server 2008 database while installing (instead of internal hsql db), no effect, as with mySQL too.

My system settings:
Win xp sp3
Jira 5.1

Thanks in advance!

1 answer

Cannot access your google doc, but I would contact Atlassian support to get some help. You can access support through your myatlassian account where you got your license from.

Okay, this issue is solved. The reason was in wrong customizing of MS SQL database. For example I set the default database for new user - jiradb, but needed master. Besides, there should not be role db_owner in user mappings, and should be datareader and datawriter. I’ll be glad to help anybody who needs more info about this issue

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,313 views 12 19
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you