ค้นหาคำถามที่พบบ่อย
PME maintenance tasks fail with error 0x1F4 if IONMaintenance user is not added to the Administrators group
Issue
PME maintenance tasks fail with error 0x1F4 if IONMaintenance user is not added to the Administrators group
In the SQL Error logs, you see the following error
"Login failed for user 'ServerName\IONMaintenance'. Reason: Failed to open the explicitly specified database 'ION_Network'. [CLIENT: <local machine>]"
Facts
Environment
PME2020 Standalone in a domain environment
Cause
The privileges granted to the group has higher priority over user privileges.
Resolution
In SQL, grant "db_backupoperator", "db_ddladmin" and "Maintenance" Membership for "BUILTIN\Users" for all PME databases
PME maintenance tasks fail with error 0x1F4 if IONMaintenance user is not added to the Administrators group
In the SQL Error logs, you see the following error
"Login failed for user 'ServerName\IONMaintenance'. Reason: Failed to open the explicitly specified database 'ION_Network'. [CLIENT: <local machine>]"
Facts
- If IONMaintenance user is added to windows administrator group, the tasks run successfully
- IONMaintenance user roles are correctly set up in SQL for the 4 PME databases
- IONMaintenance user has full write access to the Backup destination folder
- The IONMaintenance is member of "Users" group
Environment
PME2020 Standalone in a domain environment
Cause
The privileges granted to the group has higher priority over user privileges.
Resolution
In SQL, grant "db_backupoperator", "db_ddladmin" and "Maintenance" Membership for "BUILTIN\Users" for all PME databases
เผยแพร่สำหรับ:ชไนเดอร์ อิเล็คทริค Thailand
ดูข้อมูลเพิ่มเติม
ประเภท:
ดูข้อมูลเพิ่มเติม
ประเภท: