Database maintenance account requirements
PME uses Task Scheduler in Windows for the scheduling and execution of database maintenance tasks. Task Scheduler requires a Windows account to run the tasks. In Standalone PME systems, an account, IONMaintenance, is created by the installer and automatically assigned to the Task Manager tasks. In Distributed PME systems you need to create an account manually. This account must meet the following minimum requirements:
In Windows on the computer where the database server is installed, the account:
- must be a member of the Users group.
- must have the following Windows policy settings: Log on as a batch; Deny log on locally.
In SQL Server, the account:
- must have a public server role
- (for archive task only) must have a sysadmin server role
- must have the following role memberships for the PME databases (ION_Data, ION_Network, ION_SystemLog, ApplicationModules):
- db_backupoperator
- db_ddladmin
- Maintenance
- public
NOTE: You will need the password for this account during the initial task setup, and later if you want to edit the tasks in Task Manager in the future.