Stage 1: Checking the server prerequisites

What you need to do

In this stage, you need to check that the necessary prerequisites are installed.

Installation prerequisites

See the Software Requirements guide for details of all the versions supported.

Software

Description

Windows Server 2016 or later

The Windows Server environment.

Microsoft .NET Framework 4.7.2+

The software development framework used by Pegasus in the development of Opera 3 SQL SE.

Microsoft SQL Server 2014+

The data store technology used for Opera 3 SQL SE.

The Software Requirements guide lists the supported versions of Microsoft SQL Server.

Microsoft Report Viewer 2015 Runtime

This is needed for viewing reports that were designed for the Server Data Intensive Processes that are run on the Opera 3 SQL SE server.

Is Microsoft .NET Framework 4.7.2+ installed?

If necessary, download and install from www.microsoft.com/en-us/download/details.aspx?id=49982.

The easiest way to check the version of .NET that is installed is to check the registry.

Follow these instructions.

  1. Run 'regedit' from the Start menu (run as administrator).

  2. In the Registry Editor, open the following subkey: 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full'. The version number is shown below Full.

If the Full subkey is not present, then .NET Framework 4.7.2+ may not be installed. Different registry keys may be used in some Windows operating systems.

In SQL Server 2014+, is the TCP/IP protocol enabled and does the Windows account have an appropriate role?

In SQL Server Configuration Manager

Make sure that the TCP/IP protocol is enabled for MSSQLSERVER (or the appropriate instance).

Follow these instructions.

  1. On the server, click Start and type 'SQL Server'. Then click SQL Server Configuration Manager.

  2. In the left pane, select Client Protocols under SQL Native Client Configuration.

  3. Make sure that 'TCP/IP' is set to 'Enabled'.

  4. Do the same for all 'TCP/IP' protocols in SQL Server Configuration Manager.

  5. Close SQL Server Configuration Manager.

In SQL Server Management Studio

Make sure that the NT AUTHORITY\SYSTEM local Windows account is granted the role of 'dbcreator'. The Opera 3 SQL SE service uses this account as the Local System account to connect to Microsoft SQL Server.

Follow these instructions.

  1. On the server, click Start and type 'SQL Server'. Then click SQL Server Management Studio and connect to Microsoft SQL Server.

  2. In the left pane, select Security and then Logins.

  3. Open the Properties dialog for the NT AUTHORITY\SYSTEM account and open the Server Roles page.

  4. Under Server Roles, make sure 'dbcreator' is selected and close the dialog.

  5. Close SQL Server Management Studio.

Is Microsoft Report Viewer 2015 installed on the server?

Microsoft Report Viewer 2015 is used to view server reports.

Follow these instructions.

  1. On the server, click Start and type 'Control Panel'. Select Programs and then Programs and Features.

  2. Check that Microsoft Report Viewer 2015 Runtime is installed.

  3. If necessary, download and install from
    www.microsoft.com/en-us/download/details.aspx?id=45496

  4. Close Programs and Features.

Microsoft SQL Server System CLR Types

Microsoft SQL Server System CLR Types is a prerequisite for Microsoft Report Viewer 2015. CLR Types is part of the Microsoft SQL Server 2014 feature pack.

There are multiple files included in the download. Only download the 'ENU\x64\SQLSysClrTypes.msi' file from www.microsoft.com/en-us/download/details.aspx?id=42295.

Next stage

After completing this stage, follow stage 2 to download the software and install the Opera 3 SQL SE server software.