Creating a new Archive database in the AA Console under Configuration | Archive database may result in an error similar to the following:
"An error occurred while attempting to create the new archive database"
"An exception occurred while executing a Transact-SQL statement or batch"
Review the full error details and check for a line similar to"
"The EXECUTE permission was denied on the object 'xp_instance_regread', database 'mssqlsystemresource', schema 'sys'."
If this is in the error, the AA service account does not have the Execute permission on the system stored procedure, "xp_instance_regread". Grant the account Execute rights to this stored procedure and try to create the Archive DB again.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center