Step 2. Specify Connection Settings

At the Connection Settings step of the wizard, provide the connection settings for the selected database.

Important

Consider the following:

  • If you change the database to which Veeam Backup & Replication must be connected, make sure that the database to which Veeam Backup & Replication is currently connected is available. If not, you must stop the Veeam Backup Service on the machine where Veeam Backup & Replication is installed.
  • If you connect Veeam Backup & Replication to the database which is being used by another Veeam Backup & Replication, consider that Veeam Backup & Replication will not be able to utilize the encrypted data stored in this database. If you want to migrate the configuration database, see Migrating Configuration Database to Another SQL Server or Migrating Configuration Database to PostgreSQL Server.
  • When you migrate the configuration database to another server, you must use the Microsoft SQL Server credentials that have CREATE ANY DATABASE permission on the target Microsoft SQL Server. For details, see Microsoft Docs.

After database creation this account automatically gets a db_owner role and can perform all operations with the database. If the current account does not have this permission, a Database Administrator may create an empty database in advance and grant the db_owner role to the account that will be used for migration of the configuration database.

Providing connection settings for Microsoft SQL Server:

  1. Specify the Microsoft SQL Server database engine.
  2. Specify an instance and a database name to which you want the Veeam Backup & Replication installation to connect in localhost\instanceName format.

Both local and remote Microsoft SQL Server instances are supported. Instances available on the network are shown in the Instance name list. If necessary, click Refresh to get the latest information.

If a database with the specified name does not exist on the selected instance, it will be created anew.

  1. Select the authentication method that will be used for database connection.
    • If you plan to use the Microsoft Windows authentication, consider that the current service account will be used (that is, the account under which the Veeam Backup Service is running).
    • If you plan to use the Microsoft SQL Server native authentication, provide a login name and a password. To view the entered password, click and hold the eye icon on the right of the Password field.

Step 2. Specify Connection Settings 

Providing connection settings for PostgreSQL:

  1. Specify the PostgreSQL database engine.
  2. Specify an instance and a database name to which you want the Veeam Backup & Replication installation to connect in localhost:instancePort format.

Both local and remote PostgreSQL instances are supported. If a database with the specified name does not exist on the selected PostgreSQL instance, it will be created anew.

  1. Select the authentication method that will be used for database connection:
    • If you plan to use the Microsoft Windows authentication, consider that the current service account will be used (that is, the account under which the Veeam Backup Service is running).
    • If you plan to use the PostgreSQL native authentication, provide a login name and a password. To view the entered password, click and hold the eye icon on the right of the Password field.

Step 2. Specify Connection Settings 

Page updated 2/2/2024

Page content applies to build 12.1.2.172