When attempting to startup SDL Tridion, this fails with error "Automation error The specified module could not be found"

When attempting to startup SDL Tridion, this fails with error "Automation error The specified module could not be found" as in below screenshot.

Issue resolved after repairing MSXML 4.0 on Content Manager server.  Issue may also be encountered if MSXML 4.0 is not installed.

MSXML 4.0 is an old component required by older versions of Tridion, and it may have been removed by system scan or update (either automated or human).  If possible, it is advisable to verify how it was removed or effected to prevent the same issue from happening again. Unfortunately SDL Support is unable to detail why this component was removed.

Also see KB article In SDL Tridion, missing msxml4.dll file causes invalid license error while logging in to CMS