The Confluence Installation Wizard will guide you step-by-stage in configuring the SQL Server database to be installed in confluence.
Using a JDBC connection (default)
JDBC is the recommended way to connect your confluence to the database.
The Confluence Installation Wizard will provide you with the following 2 connection options:
- Simple --this is the simplest way to connect your confluence to the database.
- through the connection string-- using this option, you need to configure specific parameters at the same time you also need to have some database connection aspects just to build the correct connection URL.
Based on the type you set, you need to provide some of the following parameters.
Easy (Simple) |
Host name (Hostname) |
The host name or IP address used by your database server. |
Easy (Simple) |
Ports (Port) |
The port of the SQL Server data server. If you did not modify the SQL Server when you installed it, the default port is 1433 . |
Easy (Simple) |
Database name (db name) |
This is the name of your confluence database, as in the example above, namedconfluence |
simple |
instance name (Instance name) |
Want to find your instance name, connect to your database and run the following command:
select serverproperty ( ' instancename ' |
If your default instance name is SQL Server, you do not need to specify this parameter. |
Through the connection string (by connection string) |
Database URL (db URL) |
The URL of the database uses the following format: Jdbc:sqlserver://For example:
jdbc:sqlserver://yourserver:1433;database=confluence |
also required (Both) |
User name (Username) |
The user name you need to connect to the database, in the example above, the user name is confluenceuser . |
also required (Both) |
User password (Password) |
The user name password you need to connect to the database. |
Using JNDI data sources
If you want to use the Jdni data source, please refer to the content in configuring a DataSource connection for configuration. You need to configure before starting confluence, and in the Setup wizard, confluence only uses the options provided in your Tomcat configuration.
Https://www.cwiki.us/display/CONFLUENCEWIKI/Database+Setup+for+SQL+Server
Confluence 6 SQL Server Enter your database details