Power Monitoring Expert - ION_Data Archive Task fails due to insufficient permissions for IONMaintenance.
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, these Windows tasks are 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.0
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024
Environment
Database Archiving
Windows Tasks Scheduler
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.
Released for: Schneider Electric Canada
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales inquiry online and en expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Center
Find support resources for all your needs, in one place.