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 (

To resolve this issue I had to add user ‘NT Service\MSSQLServerOLAPService’ into the database, give it READ access. 


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s