Corruption of the database owner record

Email It to Me Print this Page
Symptoms Database cannot be accessed and you get 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 In Microsoft SQL Server Management Studio, run the following command: “ALTER AUTHORIZATION ON DATABASE::db_name TO user_name”, where “db_name” is a name of the corrupted database and “user_name” is the db owner account name.
(*) Netwrix Auditor replaces former Change Reporter products
Was this information helpful?