Upgrading from EO/EE 4.2.x to 5.2 fails and the installation rolls back

Problem:

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.

Cause:

The Service account being used is not the original account to create the EQCAS database.

Solution:

Logon to the SQL Server with an Account that has SysAdmin Rights

Open Security->Logins

Right Click the Service account and select properties

Select Server Roles

Select / Check the SysAdmin Role

Logout

Install Equitrac and once the install has been completed the SysAdmin role can be removed from the account.