Lately I have been trying to learn SSAS. I have been going though Stacia Misner’s video from Pluralsight about SSAS basics. While trying to deploy the project I was getting the following error message:
Internal error: The operation terminated unsuccessfully.
Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of ‘Dim Customer’, Name of ‘Customer’ was being processed.
OLE DB error: OLE DB or ODBC error: Login failed for user ‘NT Service\MSSQLServerOLAPService’.; 28000; Cannot open database “AdventureWorksDW2012” requested by the login. The login failed.; 42000
I was using ‘”Inherit” for Impersonation Information. Luckily after little bit of search I found the answer from StackOverflow (http://stackoverflow.com/q/13986698).
To resolve this issue I had to add user ‘NT Service\MSSQLServerOLAPService’ into the database, give it READ access.