SSAS Deployment Error Due to Login failure

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. 

Advertisements