๐๏ธ Corruption of the database owner record
If you cannot access a database and receive "invalid owner" errors, the database owner record may be corrupted. This article explains why Netwrix Auditor can cause this and how to fix it with an ALTER AUTHORIZATION command.
๐๏ธ Could Not Allocate Space for Object (ObjectName) i
Explains the "Could not allocate space for object" error in Netwrix Auditor, lists possible causes, and provides long-term and short-term resolutions including steps to recreate the database.
๐๏ธ Database contains tables not compatible with the p
Explains how to resolve the "Database contains tables not compatible with the product" error by granting the Data Processing Account the required SQL Server permissions for Netwrix Auditor databases.
๐๏ธ Database performance loss
There is some performance loss on the database selected for auditing via the Database Content Audit feature of Netwrix Auditor for SQL Servers. This article explains why and how to reduce the SQL Server performance impact.
๐๏ธ DB_Owner has been removed from Databases
Explains how to restore a database owner if Database Content Audit in Netwrix Auditor removes the DB_OWNER role from databases.
๐๏ธ Deploying the Report Server Database
How to configure SQL Server Reporting Services for initial setup or during a Netwrix Auditor migration. Includes steps to initialize Web Service and Web Portal URLs, create the report server database, and register the Report Server with Netwrix Auditor.
๐๏ธ Error: Can Not Process SQL Commands for the Netwri
Explains how to resolve the "can not process SQL commands" error by turning off Recovery mode for the Netwrix Auditor Self Audit database and reattaching it.
๐๏ธ Error: Database Owner SID Mismatch
This article explains how to resolve the "Database owner SID mismatch" error that prevents data change monitoring in Netwrix Auditor. It includes the cause, the exact ALTER AUTHORIZATION command to run, and steps to prevent the issue from recurring.
๐๏ธ Error: Login FailedโCannot Open Database in Report
Shows how to resolve the "Cannot open database ... The login failed" error when opening Netwrix Auditor reports by assigning the db_owner role to the Audit Database Account.
๐๏ธ Error While Transaction 'DB Import' Operation
When auditing Microsoft Teams with a gMSA, Netwrix Auditor may log Event ID 2107: Error while Transaction DB Import operation - Access to the path is denied. This article explains the cause and provides step-by-step resolution.
๐๏ธ Failed to Load Registry Hive
This article addresses the warning messages related to loading user registry hives in the Netwrix Auditor, detailing the symptoms, causes, and resolutions for the errors encountered.
๐๏ธ How to Assign db_owner Permissions
how to assign db_owner permissions to the Netwrix Auditor service account using SQL Server Management Studio to ensure proper access to audit databases.
๐๏ธ How to control the size of NetwrixSQLCRAudit databases on SQL instances? And what it is needed for?
Explains how to control the size of NetwrixSQLCRAudit databases created by Netwrix Auditor on SQL Server instances and describes their purpose.
๐๏ธ How to count number of CPU cores on your Oracle Da
Learn how to determine the total number of CPU cores used by your Oracle Database deployment for Netwrix Auditor licensing by querying the CPU_CORE_COUNT_CURRENT parameter on each database instance.
๐๏ธ How to create new reporting databases
Explains how to create new reporting databases by backing up or deleting existing Netwrix databases and re-applying SQL report settings in the Netwrix Auditor console.
๐๏ธ How to get Database Content Audit working
Explains how to get Database Content Audit working for SQL Server in Netwrix Auditor by assigning the `sysadmin` role to the database owner to allow cross-database writes.
๐๏ธ How to move reporting databases to a new drive
Shows how to move Netwrix Reporting databases to a different drive by detaching and attaching the databases in SQL Management Studio.
๐๏ธ How to Recreate Alerts Database?
Shows how to recreate the Netwrix_AlertsDB database used to store Alerts data: back up the current database, recreate it in SQL Server, and restart the Netwrix Auditor Management service.
๐๏ธ How to Reduce Audit Database Size for Netwrix Audi
Shows how to reduce the Netwrix Auditor audit database size by adjusting retention settings, deleting or renaming databases, and rebuilding databases. Also explains considerations for SQL Server Express and how to estimate database growth.
๐๏ธ How to remove old Oracle Database audit events
Instructions to create a scheduled job in Oracle Database to remove old Unified Auditing events using DBMS_SCHEDULER and DBMS_AUDIT_MGMT.
๐๏ธ How to Upload Audit Data from the Long-Term Archiv
Explains how to import historical audit data from the Long-Term Archive into the SQL-based Audit Database for reporting and investigations, with a link to Netwrix Auditor documentation.
๐๏ธ I can't see changed values with Database Content A
When you enable Database Content Audit in Netwrix Auditor, a report may show only the count of modified rows without the before/after values. This article explains the two possible causes and how to resolve them.
๐๏ธ Not all changes are included in reports for Databa
When you perform bulk inserts, not all modified rows may appear in Database content audit reports. Change the SQL Server data source setting that defines how many row changes per SQL transaction are included in a report (default is `10`).
๐๏ธ Recovery Mode Changes in SQL Databases
Explains why SQL Server recovery model for Netwrix Auditor databases can change between simple and bulk-logged during State-in-Time snapshot uploads and how to handle backups for these databases.
๐๏ธ SSRS TempDB Permanently Grows Large and Occupies D
The temporary SSRS database (TempDB) can grow continuously when you run reports or investigations. This article explains the cause and shows how to grant the required permissions to the SQL Server service account to allow TempDB cleanup.
๐๏ธ The following error occurred during the SQL database content audit configuration
Explains how to resolve the SQL database content audit error "Could not obtain information about Windows NT group/user '......', error code 0x5" by granting the Netwrix Data Processing Account appropriate permissions on the SQL Server and restarting services.
๐๏ธ Warning: "The NetwrixSQLCRAudit database with audit data does not exist or cannot be accessed"
Explains possible causes and solutions for the "Warning: The NetwrixSQLCRAudit database with audit data does not exist or cannot be accessed" error when a Change Summary contains incorrect or missing data.