earth_america
user_standard Log on
action_search_stroke
earth_america
Log on to rate and give feedback 1 2 3 4 5 Log on to rate
0
Concept

Concept


Products: WebReports
Functionalities: Reports
Product version: 1.8, 1.9
4/18/2016

SQL Server

Before you can install WebReports successfully, it is imperative that the SQL Server has been installed with a particular group of settings.

SQL Server Version

Microsoft provides a number of versions of SQL Server. In order to install and run WebReports with Building Operation, you need to download and install Microsoft SQL Servers 2008 R2 or Microsoft SQL Server 2012.

The following Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 editions are supported:

  • Microsoft SQL Server 2008 R2 SP2, SP3, 64-bit (or Express with Advanced Edition, 64-bit)

  • Microsoft SQL Server 2012 Standard, 64-bit (or Express with Advanced Edition, 64-bit), Microsoft SQL Server 2012 SP1, SP2, SP3

Do not install any other version of SQL Server.

Note:

Microsoft SQL Server 2012 SP1 is required with the Windows Server 2012 R2 operating system.

Before you install SQL Server, ensure that your logon account has administrative privileges.

SQL Server Installation Settings

Before you can install WebReports successfully, it is imperative that the SQL Server has been installed with a particular group of settings.

During the installation of SQL Server, the setup wizard prompts you to select from a number of options. You must select the correct installation settings. For more information, see SQL Server Installation Settings .

SQL Server Memory Configuration

You configure the SQL server memory to ensure that the reports do not take too much time to get generated. The maximum SQL server memory can be 70% of the system memory (RAM). For more information, see Configuring SQL Server Memory .

  • WebReports Installation Overview
  • SQL Server Installation Settings
  • Configuring SQL Server Memory