Creating the Optiva database user

The Optiva application accesses the database through a SQL Server login called the Optiva_User. This is a single service account and is the only user account that needs to be created on the SQL Server instance.

To configure this account, the selected SQL Server must be configured for Mixed Mode authentication. Mixed Mode provides a login to both SQL Server and Windows.

  1. Log into SQL Server Management Studio.
  2. Connect to the selected SQL Server as a user with System Administrator privileges.
  3. Select Security > Logins. Then, select New Login from the shortcut menu.
  4. Specify a login name, select SQL Server authentication, enter a password, and then the confirmation password.
    For the login name, specify the name of the Optiva service account. It can be any valid SQL Server name. Optiva_User is recommended. This service account and password are required when you configure the Optiva server to access the database.
  5. Click OK to close the form and create the SQL Server service account. The SQL Server service account can now be assigned to the Optiva database.