Issue
The Power Monitoring Expert installer will set up Windows Scheduled Tasks for a number of database-related tasks. One of these tasks is to run database archives on a scheduled basis. By default, this Windows tasks is set up to use the IONMaintenance Windows account, and is installed in a disabled state. If the task is enabled, it fails.
Product Line
Power Monitoring Expert 8.x
Environment
Database Archiving
Cause
That task fails because the IONMaintenance Windows account does not have the required permissions to create an archived database.
Resolution
If this task is to be used, it is necessary to change the Windows account that the Windows task uses to an account that is a member of the sysadmin role in SQL Server. This is because the archive task will create a new database, and sysadmin level privileges are required to do this.
Note: As of PME 8.2, the Windows database tasks are not set up in distributed systems that use a separate database server.
The Power Monitoring Expert installer will set up Windows Scheduled Tasks for a number of database-related tasks. One of these tasks is to run database archives on a scheduled basis. By default, this Windows tasks is set up to use the IONMaintenance Windows account, and is installed in a disabled state. If the task is enabled, it fails.
Product Line
Power Monitoring Expert 8.x
Environment
Database Archiving
Cause
That task fails because the IONMaintenance Windows account does not have the required permissions to create an archived database.
Resolution
If this task is to be used, it is necessary to change the Windows account that the Windows task uses to an account that is a member of the sysadmin role in SQL Server. This is because the archive task will create a new database, and sysadmin level privileges are required to do this.
Note: As of PME 8.2, the Windows database tasks are not set up in distributed systems that use a separate database server.
Gepubliceerd voor:Schneider Electric Belgium
