OLE DB error: OLE DB or ODBC error: Login failed for user domain\username; 28000; Cannot open database "Ax2012Contoso" requested by the login. The login failed.; 42000.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of ‘Dynamics Database’, Name of ‘Dynamics Database’.
Internal error: The operation terminated unsuccessfully.
Server: The operation has been cancelled.
If this kind of error appeared while deploying the Analysis Cube. Follow these steps.
1- Make sure "SQL Server Analysis Services (MSSQLSERVER)" service is running with the same account as with "Microsoft Dynamics AX Object Serve" service is running.
2- The account under "SQL Server Analysis Services (MSSQLSERVER)" service is running should the sufficient right to access warehouse data.
To resolve this you have to give at least db_datareader to the user that the Analysis Services Service is running as on the data warehouse.
To add user rights to the data warehouse:
· Open SQL Server Management Studio.
· Expand the Security node, Expand Logins, if the username from the error message above exists in the list, right click and Properties. Otherwise right click Logins, "New Login…" and type in the correct Login Name:
· On the "User Mapping" tab check the data warehouse Map checkbox and select db_datareader for it.
