Skip to content

Configure SQL Server for AVEVA System Platform comparisons

An MS SQL Server is required for CAB comparisons. You can configure the MS SQL Server for a selected component in the component properties or for all components of a component type in the AgentStation.ini file. If the corresponding key exists in the AgentStation.ini file, the component-specific configuration is ignored.

Prerequisites

  • The MS SQL Server must be running on the computer where the comparison is carried out.
  • The comparison must be performed under a Windows user with administrator rights and full access to the MS SQL Server.
  • The MS SQL Server must be the same version as the one used by the GRNode. Example: If application server 2014 R2 is installed with MS SQL Server 2014 Standard, an MS SQL Server 2014 Standard is also required for the comparison.
  • The use of MS SQL Server Express versions are also supported. As these versions have restrictions, please ensure that your Galaxy database does not exceed them. Otherwise, the comparison cannot be performed successfully. Refer to the MS SQL Server Express documentation for details on these restrictions.

This configuration applies only to the selected component.

  1. Open the UserClient.
  2. Right-click the component and select Edit component configuration.
  3. In the Component configuration dialog, select Comparison configuration.
  4. In the Comparison configuration dialog, enter the MS SQL Server in the Project field. Various options are listed below.

Create an AgentStation.ini file with the section [WonderwareSystemPlatform] in your client archive and enter MS SQL Server instance there. Various options are listed below. This configuration applies to all Wonderware System Platform and AVEVA System Platform components.

Depending on whether it is a Default Instance or a Named Instance of MS SQL Server, specify the instance as follows:

Default Instance:

Configuration SharedMemory Port != 1433 Port1433 Example
Server= Yes No Yes
Server=ComputerName Yes No Yes DESKTOP-123
Server=ComputerName\Instance No Yes No DESKTOP-123\SQLExpress
Server=ComputerName[, Port]\Instance[, port] No Yes No DESKTOP-123\SQLExpress, 1300

Named Instance:

Configuration SharedMemory Port != 1433 Port1433 Example
Server= No No Yes
Server=ComputerName No No Yes DESKTOP-123
Server=ComputerName\Instance Yes Yes Yes DESKTOP-123\SQLExpress
Server=ComputerName[, Port]\Instance[, port] No Yes Yes DESKTOP-123\SQLExpress, 1300