Warning: The NetWrixSQLCRAudit database with audit data does not exist or cannot be accessed.

Email It to Me Print this Page
Symptoms You received a Change Summary containing incorrect data or no data at all. The attached warning.txt file or the relevant Session details contain the following message:
Warning: The NetWrixSQLCRAudit database with audit data does not exist or cannot be accessed.
Cause The issue can be caused by the following:
  1. The database was not created on the monitored server.
  2. The default Data Processing Account under which the data is collected from the monitored SQL Servers was changed.
  3. The database is in the recovery mode.
  4. The account, which is assigned the database owner role of the monitored database, has no access to NetWrixSQLCRAudit database.
Resolution To fix the issues, do the following:
  1. Check if the NetWrixSQLCRAudit database exists on the monitored server.
  2. Make sure that the account under which NetWrix SQL Server Change Reporter is running has enough privileges on the SQL Server; it must be assigned the db owner role for this database.
  3. Grant all db owners of the monitored databases rights to write into the NetWrixSQLCRAudit database. Alternatively, replace all accounts with db owner role by the account under which NetWrix SQL Server Change Reporter is run.
(*) Netwrix Auditor replaces former Change Reporter products
Was this information helpful?