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 is SQL_Latin1_General_CP1_CS_AS (case sensitive).
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
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.
Database connection fields
The sections below describe the fields you'll need to fill out when connecting Confluence to your database.