📄️ Auditing stored procedures on the SQL Server
Shows how to enable auditing of the "Date Modified" attribute for stored procedures in Netwrix Auditor for SQL Server so you can track when procedures are modified. It explains which file to edit and what lines to add or comment.
📄️ Cannot Generate SSPI Context Error in SQL Server M
Shows how to troubleshoot and resolve the "Cannot generate SSPI context" error when Netwrix Auditor or the SQL Logons Connector for Netwrix OneSecutre DSPM attempts to connect to a SQL Server instance, including causes and step-by-step resolutions.
📄️ Changing the name of your SQL Server causes databa
After you change the name of the server that hosts the SQL instance for Netwrix Auditor databases, the product can no longer connect to SQL Server and Change Summary emails may show a connection error. This article shows how to update the SQL Server instance name in the product configuration and verify SQL settings.
📄️ Configure SQL Server Auditing to Ignore Addition
Shows how to configure SQL Server auditing in Netwrix Auditor to capture updates and deletions while ignoring insertions by modifying trigger and stored procedure scripts and using exclusion rules.
📄️ Connection String Is Not Valid in SQL Server Monit
This article explains how to resolve the "Connection string is not valid" error in a SQL Server monitoring plan in Netwrix Auditor by correcting the SQL Server instance name in the monitoring plan item. It provides steps to review and edit the monitored instance and shows default vs named instance formats.
📄️ Could Not Find Stored Procedure GetAllProperties
The ReportServer database is corrupted and must be rebuilt. This article describes steps to delete and regenerate the ReportServer and ReportServerTemp databases when you encounter the GetAllProperties stored procedure error.
📄️ Empty Report Server and Report Manager URLs in SQL
Explains why report folders may be empty when accessing Report Server or Report Manager and how to resolve it by assigning the Content Manager role.
📄️ Enable TCP/IP in SQL Server
This article provides step-by-step instructions to enable the TCP/IP protocol in your SQL Server instance, which is required for Netwrix Auditor to transfer data to SQL databases.
📄️ Error: Check Your SQL Server Settings in Audit Dat
This article describes causes and resolutions for the "Error validating settings. Check your SQL Server settings." message that can occur when you configure the Audit Database in Netwrix Auditor.
📄️ How can I assign a specific user read-only permiss
Describes how to grant a specific user read-only permissions for SQL Server Reporting Services reports and how to assign database read access for Netwrix-related databases.
📄️ Migrate Reporting Database to Lower SQL Version
Steps to migrate the Reporting databases from a higher-version Microsoft SQL Server instance to a lower-version instance using either the Netwrix Auditor DB Importer or SQL Server Management Studio Generate Scripts wizard.
📄️ How I can change the trace log path on the audited
Explains how to change the trace log path on an audited SQL Server by editing the `pathstotracelogs.txt` file in the SQL Server Auditing collector directory, with syntax and example.
📄️ How Netwrix Auditor for SQL Server Collects Data
Explains how Netwrix Auditor for SQL Server collects configuration and database content change data, the traces and triggers it uses, and where audit data is stored.
📄️ How to exclude Backup events from the SQL Server C
Shows how to exclude Backup events from Netwrix Auditor for SQL Server reports by editing the omitobjlist.txt file in the product installation folder.
📄️ How to Migrate Netwrix Auditor Databases to Anothe
Shows how to migrate Netwrix Auditor databases to another Microsoft SQL Server instance, including prerequisites and step-by-step instructions for backing up, restoring, and reconfiguring reporting services.
📄️ How to remove all triggers from SQL Server databas
Shows how to remove all triggers from audited SQL Server database(s) by running the supplied Netwrix Auditor script.
📄️ Invalid User Settings Error in SQL Server Reportin
You may see the 'Invalid user credentials' error when you modify audit database settings in Netwrix Auditor. This article lists causes and resolutions.
📄️ Is It Possible to Have NDC SQL Database and Audito
Do not keep Netwrix Data Classification and Netwrix Auditor databases on the same SQL Server instance; this may cause significant performance loss. See migration guidance for moving the Netwrix Data Classification database to another server.
📄️ Netwrix Auditor Widgets Show the SQL Server Error
When you specify the default SQL instance in Netwrix Auditor, SQL Server may return error 18452 indicating a Windows authentication/login issue. This article describes possible causes and step-by-step resolutions to fix the error.
📄️ Permissions Granted Are Insufficient in SQL Server
This article explains how to resolve the 'permissions granted to user are insufficient' error when accessing SQL Server Reporting Services (SSRS) Report Manager or viewing reports in Netwrix Auditor by disabling UAC and enabling active scripting.
📄️ Recover access to a SQL Server Instance
Use PSExec to run SQL Server Management Studio as the Local System account to regain sysadmin access and assign another account sysadmin permissions.
📄️ Specify Custom SQL Server Port for Netwrix Auditor
This article explains how to specify a custom SQL Server port for Netwrix Auditor so it can communicate with the Audit Database.
📄️ SQL Server Express Database Size Reached 10GB
Explains why SQL Server Express encounters a 10 GB limit with Netwrix Auditor and provides step-by-step actions to recreate the database, stop/start services, and optimize data collection to continue using Express edition.
📄️ Tracing Was Disabled in SQL Server Monitoring Plan
Explains why Netwrix Auditor logs indicate that SQL Server tracing was disabled for a monitoring plan, and provides troubleshooting steps to restore and preserve SQL tracing for accurate auditing.
📄️ Upgrading SQL Server Instance
Explains prerequisites and verification steps for upgrading a SQL Server instance used by Netwrix Auditor, including stopping and starting services and validating database and reporting settings.
📄️ What load does SQL audit generate for a SQL server
Explains the performance impact that SQL auditing by Netwrix Auditor can have on SQL servers, especially during the initial data collection and scheduled collections.
📄️ WHO changed is showing "System" in Netwrix Auditor
Netwrix Auditor for SQL Server may show "System" in the WHO field when it cannot find the corresponding SQL Server native auditing event; this article explains why that happens and how to verify the change in the SQL Server audit logs.