Return
-
Title
Purge\archive error, "The EXECUTE permission was denied on the object 'xp_servicecontrol'" -
Description
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'.;"
-
Cause
The ChangeAuditor service account account requires SysAdmin role on the SQL server to prepare the purge\archive job.
-
Resolution
1)Provide the service account SysAdmin role via SQL Studio and create the job.
2)Fixed in ChangeAuditor 5.5.104 and higher.
-
Defect ID
TF00158823