Article ID: 126148, created on Jul 11, 2015, last review on Jul 11, 2015

  • Applies to:
  • Plesk Automation 11.5

Symptoms

Cannot add service node with role "IIS web server / MS SQL Server 2008 database server".

The task "Install additional packages on node 'mssql.example.com' according role PPA_IIS_MSSQL" fails with error:

Command 'cscript /Nologo "C:\Program Files (x86)\SWsoft\PEM/mssql_installer.vbs"' execution failed with code 1: Microsoft (R) Windows Script Host Versione 5.8
Copyright (C) Microsoft Corporation 1996-2001. Tutti i diritti riservati.

Microsoft SQL Server is already installed. To register an existing database server in PPA, go to Administration Panel > Infrastructure > Database Servers > Add Database Server.
For more information, refer to http://download1.parallels.com/ppa/11.5/docs/en-US/online/ppa_deployment_guide/71389.htm.
Error: [1] Found key 'HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstalledInstances' in registry

Cause

Despite the message states:

Found key 'HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstalledInstances' in registry

, the key does not exist in mentioned location. The error was not properly handled. It was caused by software issue PPA-2380. The fix is included in MU #12.

Resolution

  1. Update PA to the latest version:

    /usr/local/ppa/bin/ppa_update --install-updates
    
  2. Remove service node from PA.
  3. Remove corresponding database server from Infrastructure > Database Servers.
  4. Re-deploy OS on the service node from scratch.
  5. Re-add service node to PA with required roles.

Search Words

Error: [1] Found key 'HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstalledInstances' in registry

Microsoft SQL Server is already installed

modify ip address

MSSQL installation failed

e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065 33a70544d00d562bbc5b17762c4ed2b3

Email subscription for changes to this article
Save as PDF