Tuesday, January 21, 2014

Unable to process the cube after restoring to a different server...

There was an error while trying to process SSAS Cube, after restoring the cube to a different server in the same domain. The initial error shown related to credentials.
The following system error occurred:  Logon failure: unknown user name or bad password. 

Actually it is due to that the SQL Server user password is not saved. I provided the password and tried to process the cube again. But I got a different error message as below.

The following system error occurred:  The security database on the server does not have a computer account for this workstation trust relationship. 

There are different approaches mentioned in various sites to fix this issue. But I was able to easily fix this by changing the ImpersonateAccount to a domain user who have access to the Analysis Service. The user initially used was not a domain user.
Therefore if the same error is thrown, try to apply this fix and process the cube.