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.
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.
