SQL Server Authentication

Specify the credentials that the Database Configuration Wizard should use to connect to SQL Server.

The account you specify must have permission to create a new database on the server.

These credentials are used only for database configuration. You will specify the credentials for adTempus itself to use in a later step.

• Windows Authentication. Choose Windows Authentication to use integrated security for the database connection. To use this option, the LocalSystem account on this computer must be granted the necessary login and database permissions on SQL Server.

  If SQL Server is located on the same computer as adTempus, make the necessary security changes in SQL Server to grant permissions to the LocalSystem account.

  If SQL Server is running on a different computer, additional configuration is required, and the SQL Server Computer Account page (see below) will be displayed when you click Next.

• SQL Server Authentication. Choose SQL Server Authentication to connect using a user ID and password. To use this option, your SQL Server must be configured to allow SQL Server authentication.

  If the account you want adTempus to use already exists, specify the user ID and password here.

  Otherwise, adTempus can create the account for you, or you can copy the script shown at the bottom of the page and use it to create the account.

• Microsoft Entra MFA. Interactive authentication using Microsoft Entra multifactor authentication (MFA).

• Microsoft Entra Password. Uses Microsoft Entra ID user ID and password.

• Microsoft Entra Integrated. Uses integrated authentication if you are logged in to Windows and using your credentials from a federated domain, or a managed domain configured for seamless single sign-on for pass-through and password hash authentication.

• Microsoft Entra Service Principal. Authenticate using the client ID and secret of a service principal identity.

• Microsoft Entra Managed Identity. Authenticate using the managed identity of the computer where adTempus is running.