Had an issue where after upgrading SCOM 2012 to SP1, all appeared to be OK, but when trying to display a dashboard, it would error out with Login account failed. This was caused by specifying a domain account through the upgrade for the SDK account.
Changed both services back to be run as LocalService, restarted the services and all appears to be back to be normal.