Migrating WinCC v7.0 SP3 to v7.5 SP1: SQL 2008 Fix & Path

David Krause11 min read
SiemensTutorial / How-toWinCC
Licensed PE Working through this on a live machine? A Maine-licensed engineer can take it from here — included with IMD hardware, by the hour for everything else. Book an engineer

Migrating WinCC v7.0 SP3 to v7.5 SP1: SQL 2008 Repair, Migration Path, and Verification

Upgrading a Siemens WinCC V7 SCADA project is not a single jump. The supported migration chain from WinCC V7.0 SP3 to WinCC V7.5 SP1 requires an intermediate stop at WinCC V7.2, and the bundled Microsoft SQL Server 2008 R2 installer is the most common failure point on legacy virtual machines. This reference documents the proven recovery sequence (SQL repair from the WinCC installation media), the recommended host platforms, the log file locations used to diagnose installer failures, and the optional branch into TIA Portal WinCC Professional.

1. Why an Intermediate Version Is Required

WinCC V7 databases are not forward-compatible across major releases. Siemens ships a project migrator inside each WinCC installation that opens a project from the previous major version, translates the underlying SQL schema, regenerates the picture tree references, and re-compiles the C-scripts and global scripts. Because the V7.5 migrator only understands the schema produced by V7.2, attempting to open a V7.0 SP3 project directly in V7.5 produces the dialog:

"The project was created with an older version of WinCC. Use the WinCC Project Migrator to convert the project."

The supported chain is therefore:

Step Source Target SQL Server Required Database Format
1 WinCC V7.0 SP3 WinCC V7.2 (incl. SP) SQL Server 2008 R2 (64-bit) V7.2 schema
2 WinCC V7.2 WinCC V7.5 SP1 SQL Server 2012 (64-bit) V7.5 schema
3 (optional) WinCC V7.0 SP1 – V7.5 TIA Portal WinCC Professional SQL Server bundled with TIA WinCC Professional format

Skipping step 1 is technically possible with the V7.5 migrator, but it bypasses the schema validation and licensing tests that V7.2 performs on the V7.0 SP3 archive. Field reports show that direct V7.0 SP3 → V7.5 migrations can succeed on small projects but frequently fail on multi-server, redundant, or C-script-heavy projects. Use V7.2 as the pivot.

2. Prerequisites

Before beginning the migration, verify the following on the engineering workstation:

  • OS (WinCC V7.2): Windows XP Professional SP3 (32-bit), Windows 7 SP1 (32/64-bit), Windows Server 2003 R2 SP2, Windows Server 2008 R2 SP1.
  • OS (WinCC V7.5 SP1): Windows 7 SP1 (32/64-bit), Windows Server 2008 R2 SP1 (64-bit), Windows 10 (with KB updates per release notes).
  • RAM: Minimum 4 GB, recommended 8 GB for projects > 500 tags.
  • Disk: 10 GB free for installation + 2× project size for backup/archive.
  • Hypervisor (lab use): VMware Workstation/ESXi or Hyper-V provide the best compatibility for legacy OS images. VirtualBox works for WinCC V7.0 SP3 / V7.2 on Windows XP SP3 but has known issues with SQL Server 2008 R2 installer hooks — see Section 6.
  • SQL Server pre-check: Confirm no existing SQL Server instance (any version) is present before running the WinCC setup. Conflicting instances are the leading root cause of the bundled SQL 2008 R2 install failure.
  • Administrative rights: Local Administrator account is required for both setup and SQL repair.
  • Source media: WinCC V7.2 DVD/ISO and WinCC V7.5 SP1 DVD/ISO (both 64-bit recommended).
Critical: A pre-installed Microsoft SQL Server Express, Developer, or Standard edition of any version on the same machine will block the WinCC V7.2 bundled SQL 2008 R2 installer. Uninstall or rename the conflicting instance before retrying.

3. Root Cause of the SQL Server 2008 R2 Installation Failure

The error reported during the V7.2 setup — typically a generic "SQL Server 2008 R2 setup failed" message with an MSI exit code in the 1603 / 233 / 2229 range — is almost always caused by one of three conditions on a Windows XP SP3 / VirtualBox image:

  1. Remnant SQL instance: A previous aborted install left orphaned registry keys under HKLM\SOFTWARE\Microsoft\Microsoft SQL Server and folders under %ProgramFiles%\Microsoft SQL Server.
  2. Missing prerequisites: Windows Installer 4.5, .NET Framework 3.5 SP1, or Windows PowerShell 1.0 are not installed on the XP SP3 base image.
  3. Pending file rename / reboot: A prior installer requested a reboot that was never performed; SQL setup refuses to continue with the flag set.

The repair path is to run the bundled SQL repair from the setup media instead of uninstalling/reinstalling manually.

4. SQL Server 2008 R2 Repair Procedure

The bundled installer ships a repair utility on the WinCC V7.2 media. Execute the following steps from an elevated (Run as Administrator) command prompt:

  1. Open the installation folder:
    X:\WinCC_V7.2_Siemens\InstData\SQL\SQL2008R2STD\SQLFULL_ENU
    where X is your DVD drive or mounted ISO.
  2. Locate setup.exe inside the SQLFULL_ENU directory.
  3. Launch the SQL repair tool:
    setup.exe /ACTION=REPAIR /INSTANCENAME=WINCC /QS
    The /INSTANCENAME=WINCC argument matches the default instance name created by WinCC setup. If a custom instance was used during a prior install, substitute that name. The /QS flag runs quietly and only displays errors.
  4. Wait for completion. The repair can take 5–15 minutes depending on disk speed.
  5. Reboot the system regardless of the prompt (the pending file rename flag must be cleared).
  6. Re-launch the WinCC V7.2 setup from setup.exe at the root of the media. The installer will detect the existing SQL instance and continue with the WinCC components.
Tip: If the repair itself returns MSI error 1603, open %TEMP%\sqlsetup*_core.log and search for "Error: 2229". This indicates a pending reboot; reboot and re-run the repair.

5. Locating SQL Setup Logs for Diagnosis

When the installer dialog hides the underlying failure, the SQL Server setup writes detailed logs to the current user's temp folder. This is the canonical location for diagnosing V7.2 SQL failures:

%TEMP%\sqlsetup*.log
%TEMP%\sqlsetup*_core.log
%TEMP%\sqlsetup*_engine.log
%TEMP%\sqlsetup*_rs.log
%TEMP%\sqlsetup*_fulltext.log

Open the most recently modified *_core.log first; it contains the high-level phase results. Drill into *_engine.log for database engine failures. Useful search terms:

Log String Meaning Remediation
Error 233 Named pipes / shared memory conflict Enable TCP/IP in SQL Server Configuration Manager; disable named pipes
Error 1603 Fatal error during install Reboot and rerun SQL repair (Section 4)
Error 2229 Pending reboot / file rename Reboot, delete PendingFileRenameOperations reg key if stuck
MSI Error 1706 Source media not reachable Copy DVD contents to local disk; remount ISO
Perfmon counter not available Corrupt performance registry Run lodctr /r from elevated cmd

After WinCC is installed, the runtime SQL logs are written to:

C:\Program Files\Microsoft SQL Server\MSSQL10_50.WINCC\MSSQL\Log\ERRORLOG
%ProgramData%\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008 R2\

6. VirtualBox, VMware, and Hyper-V Considerations

The original report uses Oracle VM VirtualBox on Windows XP Professional SP3. WinCC V7.0 SP3 / V7.2 will install on this configuration, but VirtualBox's emulated ACPI and storage controllers expose two recurring SQL setup problems:

  • Pending reboot detection: VirtualBox guest additions sometimes leave PendingFileRenameOperations populated. SQL 2008 R2 interprets this as a fatal state and exits silently.
  • Disk controller emulation: The default SATA AHCI emulation triggers an SQL Server Setup has encountered the following error: Value cannot be Null message when the MSI attempts to enumerate disks.

The recommended remediation is to switch the virtual disk controller to LSI Logic SAS or IDE in the VirtualBox VM settings. If SQL setup still fails after two attempts, migrate the VM to VMware Workstation or Hyper-V. Both hypervisors are officially supported by the WinCC V7.2 system documentation for virtualization scenarios.

For a fresh lab environment, build Windows 7 SP1 x64 directly under VMware or Hyper-V. Windows 7 avoids the XP-specific .NET / PowerShell prerequisite chain and is the longest-supported host for both V7.2 and V7.5 SP1.

7. Project Migration Procedure: V7.0 SP3 → V7.2 → V7.5 SP1

Once the SQL repair above completes and WinCC V7.2 is installed, execute the project migration:

7.1 Migrate V7.0 SP3 → V7.2

  1. On the V7.0 SP3 source system, archive the project with WinCC Project Duplicator to a network share or external drive.
  2. Copy the *.zip archive to the V7.2 workstation.
  3. Open WinCC Explorer on the V7.2 workstation. The first launch prompts for the project migration of any older archive.
  4. Select File → Open → Retrieve, navigate to the archive, and confirm the migration dialog.
  5. The migrator updates the SQL schema, regenerates picture references, and recompiles C-scripts. Compile the project (right-click → Rebuild all) to confirm.
  6. Open the migrated project in runtime for at least 10 minutes to verify tags, alarms, and archives populate correctly.

7.2 Migrate V7.2 → V7.5 SP1

  1. On the V7.2 system, archive the now-migrated project with the Duplicator again. This is mandatory — the V7.5 migrator reads a fresh archive, not a live project.
  2. Transfer the archive to the V7.5 SP1 workstation.
  3. Open WinCC Explorer on the V7.5 SP1 workstation. The Project Migrator dialog appears automatically when an older archive is selected.
  4. Confirm migration. The V7.5 migrator performs a schema upgrade to SQL Server 2012 format and re-registers the OPC DA / OPC A&E servers.
  5. Recompile all C-scripts and VBS actions. V7.5 enforces stricter script syntax; legacy printf and uninitialized COM pointers may need updates.
  6. Run the project for a controlled burn-in (1 hour minimum) before decommissioning the V7.2 host.

8. Verification Checklist

Run the following checks on the V7.5 SP1 target before signing off the migration:

# Check Method Pass Criterion
1 Tag connection WinCC Explorer → Tag Management → right-click → Status All tags show green / OK status
2 Alarm logging Trigger one process alarm Appears in Alarm Control within 1 s
3 Tag logging Trends Control → start runtime New values appear every cycle
4 User administration Log in as Administrator with original password Login succeeds; SIMATIC Logon optional but compatible
5 C / VBS scripts Diagnostics window (apdiag.exe) → Script diagnostics No error entries over 10 min runtime
6 Redundancy (if used) Stop primary server; observe failover time Failover < 30 s; archives sync
7 SQL database size SQL Server Management Studio → report on CC_V7.5_<Project>_R Database accessible; transaction log sized appropriately
8 Licensing WinCC Explorer → Help → About → License V7.5 license key accepted; no Grace Mode banner

9. Troubleshooting Matrix

Symptom Likely Cause Fix
WinCC setup halts on SQL 2008 R2 prerequisite check Missing .NET 3.5 SP1 / PowerShell 1.0 Install via Windows XP Add/Remove Windows Components
SQL repair returns error 1603 immediately Pending reboot from guest additions or Windows Update Reboot; run lodctr /r; rerun repair
Project migrator reports corrupt project file Duplicator archive incomplete (read-only source) Clear read-only attribute on *.zip before retrieval
V7.5 SP1 setup fails on a Windows 10 host Missing KB2999226 (Universal C Runtime) Install the Windows 10 Universal C Runtime update first
OPC DA server not visible after migration DCOM settings reset on new OS Re-import the WinCC DCOM configuration (dcomcnfg)
Trends show flat-line historical data Tag logging database not migrated Re-run Duplicator with the Configuration + Runtime data option
V7.5 cannot find an older archive Archive produced by a version newer than V7.5 Confirm the source version is ≤ V7.5
WinCC runtime starts in Grace Mode V7.5 license key not transferred Reinstall license via Automation License Manager

10. Optional Path: Migrate to TIA Portal WinCC Professional

If the long-term target is TIA Portal rather than WinCC V7.5 SP1, Siemens provides a separate migration entry point. Per Siemens support entry ID 109963167 — Migration of WinCC V7 projects to TIA Portal, the supported source range for WinCC Professional migration is:

  • Minimum source: WinCC V7.0 SP1
  • Maximum source: WinCC V7.5 (without Service Pack)

V7.5 SP1 archives must first be downgraded / re-archived with V7.5 base before the TIA migrator can read them. The TIA migration uses the TIA Portal Project Migration tool, not the WinCC V7-to-V7 migrator. Note the differences:

Aspect V7 → V7 V7 → TIA WinCC Professional
Migration tool WinCC Project Migrator TIA Portal Project Migration
Target IDE WinCC Explorer (V7.5 SP1) TIA Portal (V15.1 or later)
Script engine C / VBS retained VBS only; C-scripts require manual rewrite
Multi-user editing Not supported in V7.x Supported in TIA Portal
Tag count limits Set by V7 license Set by TIA WinCC Professional license
Supported source range V7.0 SP3 → V7.2 → V7.5 V7.0 SP1 → V7.5 base only

11. Field-Proven Caveats

  • Always archive with Duplicator, never copy the project folder. Copying \<ProjectName>\ directly leaves behind open file handles and inconsistent SQL transaction logs.
  • Do not install WinCC V7.2 and V7.5 SP1 on the same host. Both share the WINCC SQL instance name; side-by-side installs corrupt the databases. Use separate physical or virtual machines.
  • Document the V7.0 SP3 license before archiving. V7.5 SP1 requires a new license; the V7.x RT/RC keys are not portable.
  • Back up the archive twice. One copy for migration, one offline copy in case the V7.5 migrator fails partway and corrupts the original.
  • Check the C-script locale. German-locale strings inside C-scripts sometimes fail under English-locale SQL Server collations. Set the OS locale of the V7.5 host to match the V7.0 SP3 source.

12. Quick-Reference Command Summary

Purpose Command
SQL 2008 R2 repair setup.exe /ACTION=REPAIR /INSTANCENAME=WINCC /QS
Reset performance counters lodctr /r
Check pending reboot reg query "HKLM\SYSTEM\CurrentControlSet\Control\Session Manager" /v PendingFileRenameOperations
List SQL logs dir %TEMP%\sqlsetup*.log
Open SQL config SQLServerManager10.msc
Open WinCC diagnostics apdiag.exe

Why does my WinCC V7.2 setup keep failing with a generic SQL Server 2008 R2 error?

The bundled SQL 2008 R2 installer fails when a conflicting SQL instance exists, prerequisites (.NET 3.5 SP1, PowerShell 1.0, Windows Installer 4.5) are missing, or a pending file rename is left from a prior install. Run setup.exe /ACTION=REPAIR /INSTANCENAME=WINCC /QS from \InstData\SQL\SQL2008R2STD\SQLFULL_ENU on the V7.2 media, reboot, and re-run the WinCC installer.

Can I skip WinCC V7.2 and migrate V7.0 SP3 directly to V7.5 SP1?

Technically yes — the V7.5 migrator can read V7.0 SP3 archives. However, for projects with C-scripts, redundancy, or more than 1,000 tags, the V7.2 intermediate step is strongly recommended because V7.2 performs schema validation and licensing checks that V7.5 cannot reverse-engineer from an older archive.

Where are the SQL Server 2008 R2 installation logs?

All SQL setup logs are written to %TEMP% with names like sqlsetup*.log, *_core.log, and *_engine.log. Open the most recent *_core.log first and search for error codes such as 1603, 233, or 2229 to identify the failure.

Is VirtualBox supported for WinCC V7.0 SP3 / V7.2?

VirtualBox works for V7.0 SP3 and V7.2 on Windows XP SP3 with the disk controller set to LSI Logic SAS or IDE. VMware Workstation/ESXi and Hyper-V are officially recommended and avoid the SQL installer issues that occasionally occur on VirtualBox.

What is the highest WinCC V7 version that can be migrated to TIA Portal?

Per Siemens support entry 109963167, the TIA Portal WinCC Professional migrator accepts archives from WinCC V7.0 SP1 through V7.5 (without Service Pack). V7.5 SP1 archives must first be re-archived with the V7.5 base release before TIA can read them.

Back to blog