Forums

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

How do I setup confluence to use my Microsoft sql server that is on the same server as confluence?

Nicholas Chiaffarelli November 21, 2018
I am having issues setting up confluence to use ms sql. Please advise.

Thank you
Nick

1 answer

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.
November 21, 2018

"Having issues" tells us nothing about the problem, other than there is one.

Could you explain what you've configured, what you've done differently to the docs and the actual errors/problems you see?

Nicholas Chiaffarelli November 21, 2018

I am getting the following error when attempting to setup Confluence to MS SQL DB

 

 Set up your database - Confluence

Collation error

The database collation 'SQL_Latin1_General_CP1_CI_AS' is not supported by Confluence. You need to use 'SQL_Latin1_General_CP1_CS_AS'. Learn more 

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.
November 21, 2018

Ok, you'll need to correct the configuration of the MS-SQL server in order to proceed.  The reason and changes you need to make are in the documentation linked to by the error message you've pasted.

Once you've fixed the collation, you'll simply be able to run the installation again and select the corrected database.

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.
November 21, 2018

Yes,

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events