Databases

Select the required node:

• Management > Management Databases
• Personalization > Personalization Databases

The product Database Summary page displays in the work area.

Select CREATE NEW to display the New Database Connection page.

Choose the Server Name that will host the new database.

You must select the Encrypt Connection checkbox in order to select the Validate Server Certificate checkbox.

Enter the Configuration Account details:

The Configuration Account must be different from the Service Account. For further details on Configuration and Service Accounts, see Database Accounts and Privileges.

1. Enter the username and password for the Configuration Account.
2. Select the Authentication type:
   • Windows Authentication - A Windows account and password must be specified to access the database.

     Local Windows accounts are not supported; you must use a domain account.

   • SQL Authentication - A SQL Authentication account must be specified to access the database.

3. Select CHECK to validate the credentials.

Select SQL Database Name to display all known databases or to create a new one.

• To create a new database:

  1. Ensure the Configuration Account has dbcreator server privileges.

  2. Enter a unique database name in the SQL Database Name field.

• To set up the schema on a new, empty database:

  1. Ensure the Configuration Account is the database owner or a member of the db_owner role.

  2. Select the database from the SQL Database Name list.

• To upgrade an existing database, ensure the Configuration Account has dbo privilege, and select the database from the list.

  Always back up your database before performing an upgrade.

• To use an existing database, ensure the Configuration Account is a member of the ManagementServerAdministrator or dbo database roles.

Enter the Service Account details:

The Service Account must be different from the Configuration Account. For further details on Configuration and Service accounts, see Database Accounts and Privileges.

1. Enter the username and password for the Service Account.

   If the Service Account does not already exist in the SQL Server and the Configuration Account has securityadmin server privileges, the account will be created.

2. Select the Authentication type:
   • Windows Authentication - A Windows account and password must be specified to access the database.

     Local Windows accounts are not supported; you must use a domain account.

   • SQL Authentication - A SQL Authentication account must be specified to access the database. Accounts are created in the SQL Server.

   • gMSA - Enter the Service Account name with a terminal $ to indicate a virtual or special account.

     Mydomain\psaaccount

     The password field is disabled for the gMSA authentication option.

3. Select CHECK to validate the credentials.

   This does not test whether the gMSA successfully connects to the database. It only verifies that the account exists in AD.

Select CREATE to start the database creation.

Once created, the database displays in the tree structure under the relevant node.

Select the required node:

• Management > Management Databases
• Personalization > Personalization Databases

The product Database Summary page displays in the work area.

Select the database that you want to change. The database Detail page displays in the work area.

You must select Encrypt Connection in order to select Validate Server Certificate.

The Configuration Account must have dbo privileges and be a member of the ManagementServerAdministrator or db_owner role.

1. Change the username and enter the password.

2. Select the Authentication Type:

   • Windows Authentication: A Windows account and password must be specified to access the database.
   • SQL Authentication: A SQL Authentication account must be specified to access the database.
3. Select CHECK to validate the credentials.

1. Update the username, and enter the password.

   If the Service Account does not already exist in the SQL Server and the Configuration Account has securityadmin server privileges, the account will be created.

2. Select the Authentication Type:

   • Windows Authentication: A Windows username and password must be supplied each time access to the database is required.
   • SQL Authentication: Specify a SQL Authentication account to provide access to the database.

   • gMSA - Enter the Service Account name with a terminal $ to indicate a virtual or special account.

     Mydomain\psaaccount

     The password field is disabled for the gMSA authentication option.

3. Select CHECK to validate the credentials.

   This does not test whether the gMSA successfully connects to the database. It only verifies that the account exists in AD.