Article ID: 117422, created on Sep 21, 2013, last review on Aug 12, 2014

  • Applies to:
  • Sitebuilder 4.x for Windows
  • Sitebuilder 3.x for Windows


The following error appears when upgrade with the autoinstaller:

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.

How to troubleshoot?


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:

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,  

The error appeared in line 1388 of the installer:

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


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

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

    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.

Search Words

The upgrade patch cannot be installed by the Windows Installer service

Custom action ChangeDBOwner script error

fad6dc0c8e983c17ae70a51ac7952cd0 56797cefb1efc9130f7c48a7d1db0f0c 2a62cbceb986d1b8f45bcd3ff4cb29a5 45e8c8798afdb3e279a2f84bd498d19e 93f446740d9580dddb9bb3472eff2c82

Email subscription for changes to this article
Save as PDF