As a rule, Netwrix Auditor can use Reporting Services with the default settings. However, to ensure that Reporting Services is properly configured, perform the following procedure:
NOTE: You must be logged in as a member of the local Administrators group on the computer where SQL Server 2016 Express is installed.
Navigate to Start → All Apps → SQL ServerReporting Services Configuration Manager.
In the Reporting Services Configuration Connection dialog, make sure that your local report server instance (for example, SQLExpress) is selected, and click Connect.
In the Reporting Services Configuration Manager left pane, select Web Service URL. Make sure that:
- Virtual Directory is set to ReportServer_<YourSqlServerInstanceName> (e.g., ReportServer_SQLEXPRESS for SQLEXPRESS instance)
- TCP Port is set to 80
In the Reporting Services Configuration Manager left pane, select Database. Make sure that the SQL Server Name and Database Name fields contain correct values. If necessary, click Change Database and complete the Report Server Database Configuration wizard.
- In the Reporting Services Configuration Manager left pane, select Report Manager URL. Make sure Virtual Directory is set correctly, and that the URL is valid.