Concept
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 EcoStruxure Building Operation software, you need to download and install Microsoft SQL Server 2008 R2, Microsoft SQL Server 2012, Microsoft SQL Server 2014, or Microsoft SQL Server 2016.
The following Microsoft SQL Server 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
Microsoft SQL Server 2014, 64-bit (Enterprise, Standard, or Express with Advanced Services), SP1 or later
Microsoft SQL Server 2016, 64-bit (Enterprise, Standard, or Express with Advanced Services), SP1 or later
Do not install any other version of SQL Server.
Microsoft SQL Server 2012 SP1 (or later Service Pack) 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