Service Manager 2010 SP1 CU2 install fails with “An error occurred while executing a custom action:_ExecuteSqlScripts”

You receive the following error when installing Cumulative Update 2 for System Centre Service Manager SP1:

“An error occurred while executing a custom action:_ExecuteSqlScripts”

Solution:

Add the service account to the sysadmin group in SQL