Installation of Enterprise Console database fails with message 'Script execution failed'

Issue
When attempting to install the Sophos database to version 4 after a failed or cancelled upgrade, you see an error such as:

Script execution failed. RunAllScripts2.lmp: batch file returned error code 1

Known to apply to the following Sophos products and versions
Enterprise Console 4.0

What to do

Most likely, there is an existing SOPHOS4 database file in the SQL data directory. Remove the database file as follows:

Use SQL Management Studio

1. Connect to the Sophos SQL database.
2. In the Tree view, expand the Databases folder and right-click SOPHOS4.
3. Select Delete and then OK to confirm the removal.

Or use the command line to type the following

cd C:\

osql -E -S .\Sophos (or a custom name you have given the Sophos database) -Q "drop database SOPHOS4"