DirectAudit 2.x on Windows platform
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.
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: