Forums

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

Installed jira latest version with MS Sql 2012 DB connection was success jira running db collation

Mahesh Kallepalli
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.
July 3, 2019

Hello ,

 

We have Installed latest Jira version and connected to MS SQL 2012 database Jira is up and running but not able to create project . We have checked in Instant health check up it is showing database collation error . Can any one help me to steps to resolve this error .

 

Thanks & Regards

Mahesh

1 answer

0 votes
Shankar Asam {Appfire}
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.
July 3, 2019

Hi Mahesh, 

As per the Atlassian, the supported collation types are,  SQL_Latin1_General_CP437_CI_AI and Latin1_General_CI_AI for MS SQL database. 

Please refer to this doc for more info (See collation types):- 

https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2012-938846858.html

 

Thanks

Mahesh Kallepalli
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.
July 3, 2019

@Shankar Asam {Appfire} 

 

We are tried to change but it is not changing at this moment , shall we need to create another DB and connect ?

Shankar Asam {Appfire}
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.
July 3, 2019

yes  @Mahesh Kallepalli ,  you can try that approach to create a new DB with correct collation type.

 

Please see if this document helps you in this regard,

https://confluence.atlassian.com/jirakb/how-to-fix-the-collation-of-a-microsoft-sql-server-jira-database-776646810.html

 

-Shankar

Like Mahesh Kallepalli likes this
Mahesh Kallepalli
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.
July 3, 2019

Thank you 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events