Problem

When using an unsupported Azure SQL Database with the Bitbucket Data Center, Bitbucket does not detect the Azure SQL as an unsupported database. Instead, it identifies it as an MSSQL Server because the Azure SQL backend engine is reported as Microsoft SQL Server 12.0.5688.

You observe the following alert: Support for Microsoft SQL Server 12.0.5688 has been deprecated and will be removed in an upcoming release. However, the backend DB is Azure SQL DB and not Microsoft SQL Server 2014.

More info on the Supported Databases can be found here Supported platforms

This is reproducible on Data Center: (yes)
 

Steps to Reproduce

• Install Bitbucket with Azure SQL as the backend database. The following WARNING is observed on Bitbucket Data Center:

Expected Results

The WARNING should indicate that Microsoft Azure SQL is not a supported database platform.

Actual Results

• This misleading WARNING is displayed in the Bitbucket UI when an Azure SQL database is connected to a Bitbucket version where Microsoft SQL Server 2014 is deprecated. (For Example on Bitbucket 8.19.x LTS)
• In Bitbucket versions where Microsoft SQL Server 2014 is not supported at all, if Bitbucket is started with Azure SQL as the backend database, it won’t start and will throw a proper exception.
  • This is because Bitbucket identifies the Azure SQL server as Microsoft SQL Server 2014, which is not a supported database on that specific version. For example, this issue occurs on version 9.x of Bitbucket.

Workaround

There is no workaround for this behavior. Since Azure SQL is not a supported platform, you should migrate to a supported Database.

There is a feature request to have Azure SQL Server as a supported databases for Bitbucket Data Center

• BSERV-5054: As an admin, I want Bitbucket Server to support SQL Azure as a backend database.