Skip to content

Configuring an SQL Server for comparison

You need an MS SQL Server for the CAB comparison. You can configure this 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-related configuration becomes ineffective.

Prerequisites

  • The MS SQL Server must be running on the computer on which the comparison is carried out.
  • The comparison must be carried out under a Windows User with administrator rights and full access to the MS SQL Server.
  • The MS SQL Server must have the same version as the MS SQL Server of 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 is also supported. As these Express Versions have restrictions, please check that your Galaxy database does not exceed these. Otherwise the comparison cannot be performed successfully. Please refer to the MS SQL Server Express documentation for the restrictions.

This configuration only applies to the selected component.

  1. Open the UserClient.
  2. Right-click to open the Edit component configuration function.
  3. In the Component configuration dialog, click on Comparator configuration.
  4. In the Comparison configuration dialog, enter the MS SQL Server in the Project field. You have various options for this, which are listed below.

Create a AgentStation.ini file with the section [WonderwareSystemPlatform] in your client archive and enter the instance of the MS SQL Server there. You have various options for doing this, which are listed below. This configuration applies to all Wonderware System Platform or AVEVA System Platform components.

Depending on whether it is a Default Instance or a Named Instance of an MS SQL Server, the instance can be specified 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