Jira triall version 6.2.5 is running fine with HSQL but when changing the database configuration to SQL server 2008 then Jira application is not running . So is there any incompatibility there with jira trail version with SQL server 2008 ?

Can any one please give some pointer on this.



2 answers

any pointer on this is highly appreciated.

0 votes

MS SQL server 2008 is fully supported.

I should point out that a Jira "trial" is actually a complete and full Jira system which has a licence that will expire. There's no difference in the code. To convert a "trial" to a "full" system, you just put in a full licence and you're done.

Anyway, the question now is to fix the install of Jira -> MS SQL. Start with the log - as Jira starts up and fails to connect to it, it will write something to the log which will almost certainly have a useful error message in it (like "can't resolve host", "can't create tables because of permissions", "wrong username/password" etc)

Thankss Nic.

After switching to SQL server the Jira service is starting properly without any kind of error related to database connectivity.

But while enering the jira URL in the browser the login page is not coming by typing http://localhost:9090/.

I am typing this URL from the same server where Jira is running.

But while reverting back from SQL server to HSQL then jira is running fine and also allowing me to operate.



You need to check that

a) The installation that is connected to MS-SQL is actually listening on the machine on port 9090

b) Your log file really doesn't have any errors as it starts up

Thanks Nic.

Now its working fine. I did nothing big. After hiiting the same URL it asked me to fill some details like Full Name, admin ID name,password,confirm password, ccompany name etc.

But what I observed is the data was present in HSQL is not being reflected in SQL server 2008. Even not a single record of any table is reflected in SQL server after switching the DB.

So is there any to impoet the previos data to sql server through Jira.



I'm really not sure why you'd expect data to magically transfer from one database to another without you dooing anything, but hey.

To migrate, start at

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in Jira

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,120 views 0 8
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