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?
Execute the latest installer on the server:
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<---
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.
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.