Banks, credit unions, insurance companies,
Error: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases..."
|Symptoms||When generating reports in Netwrix Auditor or web browser the following error occurs:
"An error has occurred during report processing. (rsProcessinsAborted)
Cannot create a connection to data source 'DS'. (esErrorOpeningConnection)
The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database." is not supported in this edition of Reporting Services"
|Cause||You have Reporting Services configured on a SQL Server Express instance while the database containing your audit data is stored on a remote SQL Server instance. The Reporting Services configured on a SQL Server Express allow generating reports based on data stored in the local instance of SQL Server only.
|Resolution||Install and configure SSRS on the same SQL Server instance where the databases with your audit data are stored.|