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.
Publié pour: Schneider Electric Belgium
Besoin d'aide ?
Sélectionnez le bon produit
Trouvez rapidement et facilement les produits et accessoires adaptés à vos applications.
Obtenir un devis
Effectuez une demande de renseignements en ligne et un expert vous contactera.
Où acheter ?
Trouvez facilement le distributeur Schneider Electric local le plus proche.
Centre d'aide
Trouvez des ressources de support pour tous vos besoins, en un seul endroit.
