Changing the server role of the NT AUTHORITY\SYSTEM account to sysadmin cured the login error.

I now get an error 'A connection could not be made to thedata source with the DataSourceID of 'Adventure Works DW2012'.

Can anyone help with this ?