Connecting Confluence applications to Azure SQL

Still need help?

The Atlassian Community is here for you.

Ask the community

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 and Latin1_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.

tip/resting Created with Sketch.

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.

    Show me how to do this...

    The Confluence setup wizard will display when you access Confluence for the first time in your browser.

    1. In the first screen, set Database Connection to My own database.
    2. Set Database Type to Microsoft SQL Server.
    3. Fill out the fields, as described in the Database connection fields section below.
    4. Test your connection and save.
  • 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.

    Show me how to do this...
    1. Run the Confluence configuration tool as follows:
    2. Navigate to the Database tab and set Database type to Microsoft SQL Server.
    3. Fill out the fields, as described in the Database connection fields section below.
    4. Test your connection and save.
    5. Restart Confluence. 

Database connection fields

The sections below describe the fields you'll need to fill out when connecting Confluence to your database. 


In Setup Wizard/Configuration tool...
FieldDescription / Example
Hostname

The name or IP address of the Azure SQL server. 

Example: sqlserver.database.windows.net

Port

The TCP/IP port that the Azure SQL server is listening on. You can leave this blank to use the default port.

Default: 1433

Database

The name of your Azure SQL database (into which Confluence will save its data).

Example: Confluencedb

Username

The user that Confluence uses to connect to the SQL Server server.

Example: Confluencedbuser@sqlserver

PasswordThe user's password — used to authenticate with the Azure SQL server.
Schema

The name of the schema that your Azure SQL database uses. 

Default: dbo

In confluence.cfg.xml...
FieldDescription / Example
Hostname

The name or IP address of the Azure SQL server. 

-

<url>jdbc:sqlserver://;serverName=sqlserver. database.windows.net;

portNumber=1433;databaseName=Confluencedb</url>

Port

The TCP/IP port that the Azure SQL server is listening on. You can leave this blank to use the default port.

-

<url>jdbc:sqlserver://;serverName=sqlserver.database.windows.net;

portNumber=1433;databaseName=Confluencedb</url>


Database

The name of your Azure SQL database (into which Confluence will save its data).

-

<url>jdbc:sqlserver://;serverName=sqlserver.database.windows.net;

portNumber=1433;databaseName=Confluencedb</url>

Username

The user that Confluence uses to connect to the SQL Server server.

-

<username>Confluencedbuser</username>

Password

The user's password — used to authenticate with the Azure SQL server.

-

<password>yourpassword</password>

Schema

The name of the schema that your Azure SQL database uses.

-

<schema-name> dbo </schema-name>

Last modified on Dec 28, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.