Skip to content

Configuring the comparison for Siemens SIMATIC WinCC

You can configure the comparator for the component or for individual jobs.

  1. Open the Comparison configuration dialog.

    Figure: Comparison configuration dialog

  2. If there are several projects in a component, select the corresponding project from the dropdown menu.

  3. Select the Ignore computer name when comparing checkbox if the computer name may have been changed by WinCC under certain circumstances.

    Example: One of the two compare partners was distributed to a visualization.

  4. Select the Ignore application type of the project when comparing checkbox, if the application type may have been changed by WinCC under certain circumstances.

    Example: One of the two compare partners was distributed to a visualization.

  5. Select the Ignore user when comparing (if the user is a Web Navigator) checkbox.

    There are three possible scenarios:

    • Both compare partners have the Web Navigator property enabled.
    • In the Users different case, at least one of the two users has the Web Navigator property enabled.
    • In the User inserted or User deleted case, the existing user has the Web Navigator property enabled.

  6. Select OK to confirm.

FAQ

The WinCC comparison is terminated with errors when creating a backup with an Upload and Compare agent

The following error messages are displayed in the Event log of the executed job in AdminClient > Jobs:

  • SQLDriverConnect(), Ret: -1, State: S1000, Native: 0, Msg: [Microsoft][ODBC SQL Server Driver]The SSPI context cannot be created[21053]

  • Error adding the database {Drive}:\vdAgentArchive\VD_TMP_VD\{Path}\{File}.MDF to the MSSQL database system [21055]

  • SQLDriverConnect(), Ret: -1, State: S1000, Native: 0, Msg: [Microsoft][ODBC SQL Server Driver]The SSPI context cannot be created [21053]

  • Comparison version with backup ended with errors

Solution

Change the Microsoft SQL Server settings on the Agent PC as follows:

The steps may vary depending on the operating system and SQL Server instance used.

  1. Start the SQL Server Configuration Manager.
  2. Open the Start menu via the Windows Start button.

  3. In the Start menu, go to: Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.
    The SQL Server Configuration Manager opens.

  4. Open the logs for SQLEXPRESS:

  5. Select the following branch in the tree structure in the left-hand area of the dialog: SQL Server 2005-Network Configuration > Protocols for SQLEXPRESS

Adjusting the properties of Protocol Named Pipes.

  1. Right-click on Protocol Named Pipes in the right-hand area of the dialog.
  2. Select Properties from the context menu. The Properties of Named dialog opens.
  3. Select the Protocol tab.
  4. Select the value Yes for the Enabled property.

Adjusting the properties of TCP/IP protocol

  1. Right-click on Protocol Name TCP/IP.
  2. Select Properties from the context menu. The Properties of TCP/IP dialog opens.
  3. Select the Protocol tab.
  4. Select the value No for the Enabled property.

Restarting the SQL server

  1. Open the Start menu via the Windows Start button.
  2. In the Start menu, go to: Settings > Control Panel. The Control Panel dialog opens.
  3. Double-click the Administrative Tools icon. The Administrative Tools dialog opens.
  4. Double-click the Services shortcut. The Services dialog opens.
  5. In the right-hand area of the dialog, sort the entries in the Name column in descending order.
  6. Right-click the SQL Server (MSSQLSERVER) item.
  7. In the context menu, select the Start new entry.
Why does the comparison of my WinCC projects fail, although a suitable SQL instance is installed?

Explanation

If the name of the SQL server instance on the affected client system differs from the octoplant default name (WINCC or WINCCFLEXEXPRESS), octoplant cannot access it.

octoplant assumes one of these names, as these are set for the majority of installations of the SQL servers included with WinCC/WinCC flexible.

Solution

If the name of the SQL server instance differs from the default, this name must be made known to octoplant.

In the following example, the instance name is set to MSSQLEXPRESS:

  1. Go to the vdClientArchive\VD$A\Configuration\Compare directory.
  2. Open the AgentStation.ini file. If the file does not exist, create it with any text editor.
  3. Insert the following content, depending on whether you want to compare WinCC or WinCC flexible. (MSSQLEXPRESS is the example name of the SQL instance.)
[WinCC]
7030=MSSQLEEXPRESS

[WinCCFlexible]
7050=MSSQLEXPRESS

Info

If the instance name WINCC or WINCCFLEXEXPRESS is entered above the above entry, which corresponds to the octoplant standard name, octoplant also expects an installed editor in addition to the SQL instance.

If this editor is not installed, the comparison will fail.

This means that if no WinCC editor is installed, WINCC or WINCCFLEXEXPRESS must not be entered as the instance name.

Info

Instructions for installing the "Microsoft SQL Server 2005 Express Edition" can be requested from the support department.