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-2976: DirectAudit "Invalid database" error after relocating the database to a new storage.

Centrify DirectAudit ,  

12 April,16 at 11:07 AM

Applies to:

DirectAudit 2.x on Windows platform



Problem:

The DirectAudit database was relocated to a separate storage and the database was down for about one hour. The database server was detached and then
re-attached back when the relocation process was done. 
 
After this, the following error is seen when opening Centrify DirectAudit Admin Console and clicking on 'Collector':

Invalid database.  The database owner does not have external access assembly permission on the SQL server





























Cause:
 

When a database is detached from a database server and attached back, the database server does not restore the value of the TRUSTWORTHY flag. This flag needs to be ON for the DA components to work properly. 

 

Solution:

This is a known Microsoft bug. 


The current workaround is to run the following SQL query after every detach-and-re-attach operation:
 

ALTER DATABASE [DBNAME] SET trustworthy ON
 

Also, verify if 'sa' is not the owner of the database, you can run the following query command to set 'sa' account as the owner: 

sp_changedbowner [sa]


SQL Studio

 

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