×
Siemens Industry Online Support
Siemens AG
Entry type: FAQ, Entry ID: 29420407, Entry date: 09/27/2017
(15)
Rate

What are the possible causes of an unsuccessful Microsoft SQL Server 2005/2010/2014 Express installation or why is creating or opening a WinCC flexible 2008 project aborted?

  • Entry
  • Associated product(s)
WinCC flexible 2008 uses the Microsoft SQL Server 2005/2010/2014 Express Edition as an integrated database. It is installed by default with WinCC flexible 2008 ES.

There are many possible causes for a defective or damaged database installation.

If installation or configuration of the Microsoft SQL Server 2005 Express Edition was unsuccessful or damaged (such as by another installation), then usually all you need to do is reinstall/reconfigure the Microsoft SQL Server 2005 Express Edition.

1. Installation problems with the Microsoft SQL Server 2005 Express

1.1 Installation of the SQL Server for WinCC V7.0 not possible

Description
The WinCC V7.0 SQL Server cannot be installed.

Possible cause
WinCC flexible Start Center is enabled.

Remedy
You can only install the WinCC V7.0 SQL Server if the WinCC flexible Start Center is disabled.

Procedure

  • Right-click the icon in the taskbar Notification Area, the so-called "tray" area of the taskbar.
  • Then click "SIMATIC WinCC flexible Auto Start > Disable.".

Note
What you should watch out for when operating Microsoft SQL Server 2005 on a PC with multiple processors or cores is explained in Entry ID: 59703368.

1.2 Installation of the SQL Server for WinCC V6.2 not possible

Description
The WinCC V6.2 SQL Server cannot be installed.

Possible cause
The influence of other SQL instances, for example.

Remedy
You can only install the WinCC V6.2 SQL Server if the WinCC flexible Instance of the Microsoft SQL Server 2005 Express Edition has been uninstalled.

Procedure
More information and notes on procedure are available in Entry ID: 30576253.

Note
What you should watch out for when operating Microsoft SQL Server 2005 on a PC with multiple processors or cores is explained in Entry ID: 59703368.

1.3 Re-installation of the SQL Server

Description
The SQL Server has to carry out a re-installation.

Possible cause
>The influence of other SQL instances, for example.

Remedy
Carry out the re-installation.

Procedure

  • Insert the product DVD.
  • Start the "setup.exe" file in the CD_1 directory.
  • Carry out the installation.
  • Accept the license agreement - but do not change the presetting in the other dialogs.
  • Reboot the PC after installation.

1.4 Problems installing Microsoft SQL Server 2005 Express with WinCC flexible 2008 up to including SP4

Description
Uninstallation of the SQL Server and re-installation of the SQL Server via the WinCC flexible Setup.

Possible cause
The user data of Microsoft SQL Server 2005 Express might be damaged.

Remedy
Uninstallation of the SQL Server and re-installation of the SQL Server.

Procedure

  • Uninstall the entries below via "Control Panel" > "Software"
    "Microsoft SQL Server 2005 Express Edition (WINCCFLEXEPRESS)"
    "Microsoft SQL Server Native Client"
    "Microsoft SQL VSS Writer"
    "Microsoft SQL Server Setup Support Files (English)".
  • Start the repair installation of WinCC flexible via "Control Panel" > "Software" >"WinCC flexible 2008" "Change" >"Repair program".
    The Setup recognizes that the SQL Server is missing and re-installs the SQL Server.
  • Now restart your operating system.
  • Start WinCC flexible and create a new project.

Note
If WinCC V11 (TIA Portal) is installed, you must do a repair installation here as well, because the uninstallation described above also removes the instance of the SQL Server from WinCC V11.

1.5 Problems installing Microsoft SQL Server 2010 Express with WinCC flexible

Description
Uninstallation of the SQL Server and re-installation of the SQL Server via the WinCC flexible Setup.

Possible cause
The user data of Microsoft SQL Server 2010 Express might be damaged.

Remedy
Uninstallation of the SQL Server and re-installation of the SQL Server.

Procedure

  • Uninstall the entries below via "Control Panel" > "Software"
    "Microsoft SQL Server 2010 Express Edition (WINCCFLEX2010)"
    "Microsoft SQL Server Native Client"
    "Microsoft SQL VSS Writer"
    "Microsoft SQL Server Setup Support Files (English)".
  • Start the repair installation of WinCC flexible via "Control Panel" > "Software" >"WinCC flexible" "Change" >"Repair program".
    The Setup recognizes that the SQL Server is missing and re-installs the SQL Server.
  • Now restart your operating system.
  • Start WinCC flexible and create a new project.

Note
If WinCC V13 (TIA Portal) is installed, you must do a repair installation here as well, because the uninstallation described above also removes the instance of the SQL Server from WinCC V13.

1.6 Problems installing Microsoft SQL Server 2014 Express with WinCC flexible SP1 or WinCC flexible 2008 SP5

Description
Uninstallation of the SQL Server and re-installation of the SQL Server via the WinCC flexible Setup.

Possible cause
The user data of Microsoft SQL Server 2014 Express might be damaged.

Remedy
Uninstallation of the SQL Server and re-installation of the SQL Server.

Procedure

  • Uninstall the entries below via "Control Panel" > "Software"
    "Microsoft SQL Server 2014 Express Edition (WINCCFLEX2014)"
    "Microsoft SQL Server Native Client"
    "Microsoft SQL VSS Writer"
    "Microsoft SQL Server Setup Support Files (English)".
  • Start the repair installation of WinCC flexible via "Control Panel" > "Software" >"WinCC flexible SP1" "Change" >"Repair program".
    The Setup recognizes that the SQL Server is missing and re-installs the SQL Server.
  • Now restart your operating system.
  • Start WinCC flexible and create a new project.

Note
If WinCC V14 (TIA Portal) is installed, you must do a repair installation here as well, because the uninstallation described above also removes the instance of the SQL Server from WinCC V14.

2. Known problems of the MS SQL Server 2005 Express with WinCC flexible

2.1 Abort when creating or opening a WinCC flexible project

Description
Creating or opening a project is aborted with an error message.

Note
See also 2.2 in the case of a Remote Desktop connection.

Possible cause
The Microsoft SQL Server 2005 Express Edition user data is possibly damaged or no longer matches the installed instance.

Remedy
Delete the folders with the user data of the WINCCFLEXEXPRESS instance.

Procedure

  • Close all instances of WinCC flexible 2008.
  • Right-click the icon in the taskbar Notification Area, the so-called "tray" area of the taskbar.
  • Then click "SIMATIC WinCC flexible Auto Start > Close."
  • Open the Windows Explorer.
  • In the Windows Explorer address bar, enter the path below including environment variable and delete the entire "WINCCFLEXEXPRESS" folder:

Windows XP
%USERPROFILE%\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\WINCCFLEXEXPRESS

or

%USERPROFILE%\Lokale Einstellungen\Anwendungsdaten\Microsoft\Microsoft SQL Server Data\WINCCFLEXEXPRESS

Windows Vista
%USERPROFILE%\AppData\Local\Microsoft\Microsoft SQL Server Data\WINCCFLEXEXPRESS


Fig. 01 - Environment variable + path

Windows 7
%USERPROFILE%\AppData\Local\Microsoft\Microsoft SQL Server Data\WINCCFLEXEXPRESS

Note
With the environment variable "%USERPROFILE%" the directory of the logged-on user is opened dynamically.

2.2 Abort when creating or opening a WinCC flexible project via the Remote Desktop connection

Description
Creating or opening a project is aborted with an error message.

Note
See also 2.1.

Possible cause
The Microsoft SQL Server 2005 Express Edition is installed on a Windows XP SP2-based computer. The user tries to gain access over Remote. The connection fails.

Remedy
Install the relevant Microsoft Hotfix for your operating system.

Procedure
This error is cleared with the Microsoft Hotfix "KB896613", which can be downloaded at this link:

English: http://support.microsoft.com/kb/896613/en-us
German: http://support.microsoft.com/kb/896613/de

Note
Please also refer here to the information given in Entry ID:28465761.

3. Known problems of the MS SQL Server 2010 Express with WinCC flexible

3.1 Abort when creating or opening a WinCC flexible project

Description
Creating or opening a project is aborted with an error message.

Possible cause
The Microsoft SQL Server 2010 Express Edition user data is possibly damaged or no longer matches the installed instance.

Remedy
Delete the folders with the user data of the WINCCFLEX2010 instance.

Procedure

  • Close all instances of WinCC flexible.
  • Open the Windows Explorer.
  • In the Windows Explorer address bar, enter the path below including environment variable and delete the entire "WINCCFLEX2010" folder:

Windows 7, Windows 8, Windows 10
%USERPROFILE%\AppData\Local\Microsoft\Microsoft SQL Server Data\WINCCFLEX2010

Note
With the environment variable "%USERPROFILE%" the directory of the logged-on user is opened dynamically.


Additional Keywords
SQL Express