Configure Microsoft SQL Server for Report Manager

Verify the existing version of your Microsoft SQL Server and review the settings below for Report Manager 5.0 SP6. If required, apply the service packs and upgrade to a new version.

The Microsoft OLE DB Driver for SQL Server is a mandatory requirement for Report Manager to function. Report Manager will not install without it.

See the Microsoft download instructions, release notes, and driver announcement for more details.

The following settings within a SQL server are critical to Report Manager. If these requirements are not met, the installation may not proceed. If installation does proceed, scheduled reporting will not occur.

See the Microsoft instructions to upgrade, install, or configure Microsoft SQL Server 2012, 2014, 2016, and 2017.

The settings below are critical and must be applied in either a new or existing installation, for Microsoft SQL server to work with Report Manager.

• Install the SQL Server as a default instance.
• Select the NT Authority\System account for SQL Server services.
• Select Mixed Mode for Database Engine Configuration.
• Ensure the following Feature Selections are applied:
  • Database Engine Services
  • Reporting Services
  • Integration Services
  • Management Tools – Complete

If you are planning on using the Scheduled Report Trending Report to determine if trends are developing for how long it takes to run scheduled reports, and you want to keep the data for more than 60 days, then adjust the Report Execution Logging setting from the Server Properties page in SQL Server Management Studio.