Search Engine: Elastic

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.

e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065 33a70544d00d562bbc5b17762c4ed2b3

Email subscription for changes to this article
Save as PDF