Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect Jira with SQL Server 2008 R2?

axchemezov May 2, 2016

JIRA configurator tell that "its okay i see connection", but when I start JIRA Service it tell that there is some error:

JIRA — Internal Server Error

Error reference: aa5fe2b7-e4a0-4c4c-8b14-7ac0bc3767d7

Unable to render full error details at this time. Please consult the error logs for more information.

Okay here is log files for today https://yadi.sk/d/eQdogeBTrRp52 (at first it was H2 data base, then I start connect SQL Server 2008 R2)

3 answers

0 votes
axchemezov May 2, 2016

Here is piece of log file Atlassian-jira.log when JIRA tryung to start https://yadi.sk/d/jixrleh7rSbhB

I think problem in this piece of log (but i dont understand what is that about):

You are using an unsupported mssql collation: Cyrillic_General_CI_AS. This may cause some functionality to not work.
Please use SQL_Latin1_General_CI_AI or SQL_Latin1_General_CP437_CI_AI as the collation instead.

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 2, 2016

Um, that chunk of log doesn't mention the collation at all.

But, it is a valid warning.  Collation is a setting about how a database compares characters in data.  You don't need to worry too much about the precise reasons why this might be a problem, but you do need to switch to a database with supported settings.

axchemezov May 2, 2016

But how looks like that supported settings? Database in MS SQL was created automatically, and JIRA can see connection if I click "Test connection", but when I Start Jira, it tell that something wrong. I was try install jTDS driver but dont find easy documentation for someone who does not know Java.I think that jTDS can resolve this problem. I look a lot web site but cant find the answer ((

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 2, 2016

No, it's not that, although I do understand why you thought that might be it, and your idea is good.

The database for MS-SQL was not created automatically.  Your database administrator had to set up an empty one, with a user who has full access to it.  JIRA then used that user to create all the base data it needed.  But, collation is a setting done at the database creation time, not initial population.  The database has been created with a collation that does not work for JIRA - you'll need to convert it to a collation type that works, or start with a new empty one that has the correct collation set at the time your admin creates it.

axchemezov May 3, 2016

Oh, thank you I think I start understand what to do next..

The database for MS-SQL was not created automatically - yes , When I make database in MS SQL I was following the instructions on the site documentation for JIRA. but probably i miss some important detail.. Dont remember anything about collation. can you please tell what collation  I will need to set when I will try make new database for jira? what collation is right for jira?

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 3, 2016
axchemezov May 3, 2016

Thank you very much. I will try following this instruction.

0 votes
Ahmad Awadallah May 2, 2016

What version of JIRA are you using?  You may be using a JIRA version that no longer supports SQL Server 2008 R2.  Was this working at one point, or is this a new setup?   

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 2, 2016

What does the JIRA application log file say the problem is?  Atlassian-jira.log in the <JIRA home>/log directory

Suggest an answer

Log in or Sign up to answer