×
Siemens Industry Online Support
Siemens AG
Entry type: FAQ Entry ID: 109767327, Entry date: 05/21/2019
(2)
Rate

How do you ensure that the SQL services can be installed properly after a function update of Windows 10?

  • Entry
  • Associated product(s)
SIMATIC WinCC and WinCC (TIA Portal) use the Microsoft SQL database. After a function update of Windows 10 it might happen that the SQL services cannot be installed or cannot be started subsequently.

Behavior
You have run a function update of Windows 10 (Windows 10 version 1709 to version 1809, for example). When you install SIMATIC WinCC you get the error message "The following program could not be installed: SQL Server 2014 Standard Edition (WinCC) Setup cannot complete the installation".

Cause
The Windows 10 function update activates the Unicode UTF-8 coding in the Region Settings.

Remedy

  1. Open the "Control Panel".
  2. In the category "Region and Language" you select "Change date, time or number format".
  3. Click the "Administration" tab and then "Change system locale".
  4. Disable the Unicode UTF-8 coding and confirm this with "OK".
  5. Reboot the system.


Note
Recommendations about using Windows Updates are available in the following application example:
109754089

If the Microsoft SQL server does not start automatically after a function update of Windows 10, help is available in this entry:
109765539


Additional Keywords
Defective installation, Setup cannot complete the installation, SQL server, SQL server 2014, UTF-8


Security information
In order to protect technical infrastructures, systems, machines and networks against cyber threats, it is necessary to implement – and continuously maintain – a holistic, state-of-the-art IT security concept. Siemens’ products and solutions constitute one element of such a concept. For more information about cyber security, please visit
https://www.siemens.com/cybersecurity#Ouraspiration.