Running ChangeAuditor 5.5.100 or 5.5.101 you may experience the following error when attempting to create purge\archive job the Client\Coordinator loose connection to the database.
The following error is found in the Coordinator log file:
"SQL error(-2146232060): Error: 229, Procedure: xp_servicecontrol, Message: The EXECUTE permission was denied on the object 'xp_servicecontrol', database 'mssqlsystemresource', schema 'sys'.;"
The ChangeAuditor service account account requires SysAdmin role on the SQL server to prepare the purge\archive job.
1)Provide the service account SysAdmin role via SQL Studio and create the job.
2)Fixed in ChangeAuditor 5.5.104 and higher.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy