Centrify

Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-10067: The Database Owner does not have External Access Assembly Permission in SQL

Centrify DirectAudit ,  

1 April,18 at 02:59 AM

Problem:
While doing an Audit SQL database rotation,the following error came up when opening the Collector on the Audit Manager:

"Invalid database. The database owner does not have External Access Assembly permission on the SQL Server"

Resolution:
Change the SQL database owner to 'sa' and set trustworthy to ON.

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.

Related Articles

 articleKB-4602: Pre-requisite SQL server and database permissions for users articleKB-2727: How to migrate SQL databases associated with a Centrify_DirectManage Audit 3.x installation from one database server to another articleKB-10203 How to rename DirectAudit Database? articleKB-3406: MS Patch KB 2840628 Causing DirectAudit Connection Loss to SQL articleKB-4371: “A database operation error occurred” & “Invalid database” error when opening Audit Manager articleKB-6073: How to join the Linux/Unix Centrify Server to Active Directory with specific Computer Role? articleKB-3040: How to run setupdb2.sh to configure Centrify DB2 plugin articleKB-6041: How to show current license type in use by adclient? articleKB-6040: How to change the license type in use after adclient successful joined to the AD?