Connecting Confluence applications to Azure SQL
These instructions will help you connect Confluence Server or Confluence Data Center to an Azure SQL database.
1. Create an Azure SQL database
Create an Azure SQL database. See Quickstart: Create a single database in Azure.
Requirements
- Collation: When creating the database, make sure to set the right collation in Additional settings, as you won't be able to change it later. Collation types supported by Confluence are
SQL_Latin1_General_CP437_CI_AI
andLatin1_General_CI_AI
.
2. Allow Confluence to connect to the database
You need to add the IP address of your Confluence server to the database's firewall rules to allow Confluence to connect to your Azure SQL database. See Azure SQL database firewall rules.
3. Configure Confluence to connect to the database
There are two ways to configure your Confluence server to connect to your Azure SQL database.
Finding connection strings
When connecting Confluence to the database, you’ll need to provide connection details, such as hostname, port number, and database name. You can find them in the Azure portal by opening your deployed database and going to Connection strings.
Using the Confluence setup wizard — Use this method, if you have just installed Confluence and are setting it up for the first time. Your settings will be saved to the file in your Confluence application home directory.
Using the Confluence configuration tool — Use this method, if you have an existing Confluence instance. Your settings will be saved to the
confluence.cfg.xml
file in your Confluence application home directory.
Database connection fields
The sections below describe the fields you'll need to fill out when connecting Confluence to your database.