When upgrading from EE/EO 4.2.X to EE/EO 5.2 the installation fails and the installation rolls back.
MSI Install Log has the following error:
IF IS_SRVROLEMEMBER('sysadmin', 'DOMAIN\USER') != 1 BEGIN EXEC sp_addsrvrolemember 'DOMAIN\USER', 'sysadmin' END
ERROR User does not have permission to perform this action.
CustomAction EQSetSQLLogins returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 18:58:26:
InstallFinalize. Return value 3.
The Service account being used is not the original account to create the EQCAS database.
Logon to the SQL Server with an Account that has SysAdmin Rights
Right Click the Service account and select properties
Select Server Roles
Select / Check the SysAdmin Role
Install Equitrac and once the install has been completed the SysAdmin role can be removed from the account.