Logon failure: unknown user name or bad password - SSAS 2012

Error Message

Internal error: The operation terminated unsuccessfully.

The following system error occurred:  Logon failure: unknown user name or bad password.

Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW2012', Name of 'Adventure Works DW2012'.

Description

This error occurred when process a cube, this is happening while process only, the cube can be deployed successfully. There can be many reasons why “a connection could not be made to the data source”, but the connection parameter all varied and all fine. This issue was happened in SQL Server 2012 environment.

Solution

Reason was Set Impersonation Options not set.

When creating a data source object in an Analysis Service model, one of the settings that you must configure is an impersonation option. This option determines whether Analysis Service assumes the identity of a specific Windows user account when performing operational related to connection, such loading an OLE DB data provider or resolving user profile information in environments that support roaming profiles.

(More info http://technet.microsoft.com/en-us/library/ms187597.aspx)

Set impersonation options in SQL Server Data Tools

1. Double-click a data source in Solution Explorer to open Data Source Designer.
2. Click the Impersonation Information tab in Data Source Designer.
3. Choose an option described in Impersonation options in this topic.

Set impersonation options in Management Studio

In Management Studio, open the Impersonation Information dialog box by clicking the ellipsis (...) button for the following properties of these dialog boxes:

1. Database Properties dialog box, through the Data Source Impersonation Info property.
2. Data Source Properties dialog box, through the Impersonation Info property.
3. Assembly Properties dialog box, through the Impersonation Info property.

Cheers!