Skip to main content

Corruption of the database owner record

Database cannot be accessed and you receive an error messages containing the invalid owner text.

Cause​

When the Database Content Audit option is selected, on each data collection Netwrix Auditor checks if the TRUSTWORTHY property is enabled on the monitored databases, and enables the property when it is disabled. Sometimes this process can corrupt the database owner record.

Resolution​

  1. In Microsoft SQL Server Management Studio, run the following command: 
    ALTER AUTHORIZATION ON DATABASE::db_name TO user_name
    • Replace db_name with the name of the corrupted database.
    • Replace user_name with the database owner account name.