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:
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")
Verify SQLUSER, SQLPWD and SQLSERVER exist in the registry:
HKLM\\Software\\SWsoft SiteBuilder for Windows
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.