Symptoms

When trying to connect to an external database supported by Bitbucket Server, the following message is displayed:

Bitbucket Server requires a case-sensitive database, but the target database is case-insensitive. For information about creating a database for use with Bitbucket Server, please refer to the Bitbucket Server documentation.

The following screen is shown:

Cause

Bitbucket Server requires that the database stores its data in a case-sensitive manner for its regular operation.

Resolution

The instructions on how to set up the database server will depend upon which database you are connecting your instance to. Please refer to the documentation for creating your database listed on Connect Bitbucket to an external database accordingly. Below we highlighted the commands related to the database creation that you need to make sure they were run.

SQL Server> ALTER DATABASE bitbucket COLLATE SQL_Latin1_General_CP1_CS_AS

mysql> CREATE DATABASE bitbucket CHARACTER SET utf8 COLLATE utf8_bin;

CREATE DATABASE bitbucket WITH ENCODING='UTF8' OWNER=bitbucketuser CONNECTION LIMIT=-1;