Cannot upgrade Parallels Plesk Sitebuilder for Windows: "The upgrade patch cannot be installed by the Windows Installer service"

Created:

2016-11-16 12:42:07 UTC

Modified:

2017-04-24 12:14:49 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot upgrade Parallels Plesk Sitebuilder for Windows: "The upgrade patch cannot be installed by the Windows Installer service"

Applicable to:

  • Plesk Sitebuilder for Windows
  • Plesk Sitebuilder 4.5 for Windows

Symptoms

The following error appears when upgrade with the autoinstaller:

---8<---
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program.
--->8---

How to troubleshoot?

Cause

Execute the latest installer on the server:

Upgrading from Version 3.x to 4.x

Find the " SBinst.msi " script under C:\Program Files\SWsoft\Install\SiteBuilder\4.5.0 (the directory may be different on your server). Run the following command to install with debug option:

> msiexec /i SBinst.msi SKIPCONFIGUREIIS=1 FORCELICENSEUPGRADE=1 /lx*v install45.log

The following error is shown in the log:

install45.log
---8<---
Error 1720. There is a problem with this Windows Installer package. A script required for this installation to complete could not be run. Contact your support personnel or package vendor. Custom action ChangeDBOwner script error -2147467259, Microsoft OLE DB Provider for SQL Server: Login failed for user ''. The user is not associated with a trusted SQL Server connection. Line 1388, Column 3,
--->8---

The error appeared in line 1388 of the installer:

--->8---
If GetProp("SQLWINAUTH") = "true" Then
cnn.ConnectionString = "Provider=SQLOLEDB;Data Source=" + GetProp("SQLSERVER") + ";Integrated Security=SSPI"
cnn.Open <== line 1388
Else
cnn.Open "Provider=SQLOLEDB;Data Source=" + GetProp("SQLSERVER"), GetProp("SQLUSER") , GetProp("SQLPWD")
End If
---8<---

Resolution

  1. Verify SQLUSER, SQLPWD and SQLSERVER exist in the registry:

    HKLM\\Software\\SWsoft SiteBuilder for Windows
    --->8---
    SQLSERVER: AU***05
    SQLUSER: 6C***93
    SQLPWD: 13***er!..
    ---8<---

    Connection to the database is possible. You may try instructions from this KB .

  2. Since the error appears on line 1388, we should create new option or change existent SQLWINAUTH to "false" in the registry. Run the installer again.

Have more questions? Submit a request
Please sign in to leave a comment.