Resolving SQL Server 2014 Installation Failures During PCS 7 Setup on Windows 10

Resolving SQL Server 2014 Installation Failures During PCS 7 Setup on Windows 10

Failure to install Microsoft SQL Server 2014 SP1 during SIMATIC PCS 7 V9.0 Engineering Station setup on Windows 10 Enterprise occurs because the operating system lacks the prerequisite Microsoft .NET Framework 3.5 runtime. Modern Windows 10 installations deliver .NET Framework 4.5/4.7 by default, but SQL Server 2014 setup bootstrappers strictly require .NET 3.5 (encompassing .NET 2.0 and 3.0). To resolve this failure, enable Microsoft .NET Framework 3.5 via Windows Features or deploy the DISM command-line utility pointing to the Windows installation media source directory, and verify the operating system build matches certified Windows 10 Enterprise LTSB specifications.

Table of Contents

SQL Server 2014 Bootstrapper and .NET Framework Dependencies

In SIMATIC PCS 7 V9.0, the core engineering and runtime databases are managed by Microsoft SQL Server 2014 SP1. During the initial phase of the automated PCS 7 installation sequence, the setup engine launches the silent Microsoft SQL Server installation bootstrapper (setup.exe /ConfigurationFile=...).

The SQL Server 2014 installation engine relies heavily on Microsoft .NET Framework 3.5 runtime components (specifically the common language runtime mscorwks.dll). While Windows 10 delivers modern .NET 4.x frameworks out of the box, legacy .NET 3.5 components are disabled by default. If the silent installer detects that .NET 3.5 is missing and cannot reach Windows Update to download the feature, the SQL Server setup aborts with exit code 0x84B10001 or 0x800F081F, halting the entire PCS 7 software installation.

Windows 10 Operating System Lifecycle and LTSB Certification

A secondary compounding factor is operating system edition mismatch. Siemens qualifies SIMATIC PCS 7 V9.0 exclusively for Windows 10 Enterprise 2015 LTSB (64-Bit, Build 10240) and Windows Server 2012 R2.

Attempting to install PCS 7 on consumer or semi-annual channel (SAC) editions (Windows 10 Pro, Enterprise 1809, 1903, etc.) frequently encounters installation barriers. Furthermore, corporate IT group policies often block local computers from contacting public Microsoft Windows Update servers, which prevents Windows from automatically downloading .NET 3.5 payload files when prompted by the Siemens installer.

Prerequisite Matrix for PCS 7 V9.0 Database Engine Installation

The table below details database engine components, operating system requirements, and installation dependencies:

Component / FeatureVersion RequirementDefault OS StateResolution / Installation MethodMicrosoft .NET Framework 3.5Version 3.5 SP1 (includes 2.0 & 3.0)Disabled on clean Windows 10Enable offline via DISM using Windows ISO \sources\sxs.Microsoft .NET Framework 4.6.2Version 4.6.2 or higherEnabled nativelyManaged automatically by Windows 10 LTSB.Microsoft SQL Server 2014SP1 Standard / Express (64-Bit)Installed via PCS 7 DVDRequires .NET 3.5 active prior to launch.Target Operating SystemWindows 10 Enterprise 2015 LTSBBuild 10240 CertifiedBaseline certified client OS for PCS 7 V9.0.Windows Update PolicyLocal WSUS / Domain PolicyOften blocks direct downloadsUse local offline installation media payload.

Step-by-Step Remediation: Enabling .NET 3.5 via DISM and Server Manager

  1. Mount Windows 10 Installation Media:
    - Insert the Windows 10 Enterprise LTSB installation DVD or mount the ISO file (e.g., mapped to drive letter D:).
    - Verify that the folder D:\sources\sxs contains the file microsoft-windows-netfx3-ondemand-package.cab.
  2. Enable .NET Framework 3.5 via DISM (Offline Method):
    - Open the Windows Command Prompt as Administrator (cmd.exe).
    - Execute the following Deployment Image Servicing and Management (DISM) command:
    cmd dism /online /enable-feature /featurename:NetFX3 /All /Source:D:\sources\sxs /LimitAccess
    - Wait for the progress bar to reach $100\%$ and confirm the message: 'The operation completed successfully'.
  3. Enable via Windows Features (Alternative Online Method):
    - Open Control Panel -> Programs and Features -> Turn Windows features on or off.
    - Check .NET Framework 3.5 (includes .NET 2.0 and 3.0) and click OK.
  4. Reboot the Workstation: Restart Windows to allow registry and servicing stack updates to initialize.
  5. Relaunch PCS 7 Setup: Insert the SIMATIC PCS 7 V9.0 DVD, launch Setup.exe with 'Run as administrator', and select the Engineering Station package. SQL Server 2014 SP1 will now install cleanly without errors.

Verification

Verify database installation success through the following milestones:
1. Confirm that the PCS 7 installation wizard proceeds through the SQL Server phase and displays 'Installation completed successfully'.
2. In Windows Administrative Tools, open Services (services.msc): verify that SQL Server (WINCC) is running and set to Automatic.
3. Open SIMATIC Manager: create a test multiproject and insert an OS object: verify that WinCC Explorer launches and connects to the local SQL Server instance without error dialogs.

Limitations and Operational Precautions

Never attempt to install Microsoft SQL Server 2014 manually from third-party Microsoft media before running PCS 7 setup. The Siemens installer must configure the SQL Server instance with certified binary collation (Latin1_General_BIN), predefined internal communication ports, and specific user group rights. Furthermore, avoid utilizing consumer Windows 10 Pro editions in production, as rolling Semi-Annual Channel (SAC) updates can disable or reconfigure .NET components without warning.

Engineer FAQ

Technical References

Related Articles

Related Tags

  • SQL Server 2014
  • .NET Framework 3.5
  • Windows 10 LTSB
  • Installation
  • DISM
  • PCS 7 V9.0
6 respuestas