When upgrading from SOI 3.3 CUM2 (ArcServe DR) to SOI 4.2, getting an error "Database Error - SQL server is not available"
Following errors may found in "%TEMP%\CA-SOI_InstallDebug.log"
SOI 3.3 CUM2
SOI Manager & UI running on separate Windows Machines
SQL 2012 with SAMStore DB is running on remote server
Solution for Cause 1:
1) From above log, the problem is with "samuser" password and it is incorrect, hence it is unable to parse this file. So, we need generate a new encrypted password using "EncryptSAMCreds.bat" and updated in both \SOI\resources\configurations\SSA_IFW_HostName-domain.net.xml and "mtc_HostName-domain.net.xml" files
Ex: EncryptSAMCreds.bat <samuser password> (from \SOI\Tools command prompt)
2) Since this SOI 3.3 is running on ArcServe D(SOI 4.2 doesn't support DR) disable 2nd SOI Manager DR entry in "SSA_IFW_HostName-domain.net.xml" as mentioned in 3.3 Wiki
Solution for Cause 2:
The eem-config.xml file located at 2 locations,
1) If the encrypted password string is incorrect in one of the above files, Upgrade | Installer cannot proceed
2) Copy encrypted password string from 1st file to second file or generate new encrypted password using "EncryptSAMCreds.bat" and then update this in both files
3) Re-run the installer
With above changes, now upgrade will continue and Manager will be upgraded to 4.2 version