Skip Navigation

(Optional) System Archive account requirement

This task is required only for new installations that use System Archive.
In order for the System Archive function to work, the
AtHoc
services application pool identities need a domain service account with
sysadmin
access on the SQL Server. A viable alternative is the built-in Local System account. However, additional configuration on SQL is required.
Add all application servers’
domain\computer$
account as a new login to SQL Server and grant it the sysadmin server role.
The backup folder path must also exist on the
Microsoft SQL Server
and the application pool identities must have write access to that folder. The backup folder path is defined in the System Setup (3) organization in System Settings.
If you use a client certificate for this server, ensure that the account has permission to access that client certificate. For more information, see (Optional) Configure client certificates on the application server.
  1. As a sysadmin, log in to the database server instance.
  2. Give sysadmin permissions to the following user:
    domain
    \"<
    app-server-name
    >$".
  3. Map the DEFAULT DATABASE to "ngaddata".
  4. As a sysadmin, log in to the
    SQL Server Management Studio
    .
  5. Open
    Object Explorer
    .
  6. Click
    server_instance_name
    >
    Security
    >
    Logins
    .
  7. Right-click
    Logins
    and then select
    New Login
    .
  8. On the folder defined in GLB_CONFIG_TAB for [key_name]"DB_ARCHIVE_LOCATION", give full permissions to the [NTAUTHORITY\SYTEM] login and sysadmin permissions to the database server instance.
  9. On the application server, open the registry.
  10. Edit the OleDbConnectionString value to add the following string at the end:
    Trusted_Connection=True
    .
  11. As an administrator, at the command prompt, run the
    IISRESET
    command to restart IIS.