Exception occurs while processing SSAS cube

Question

while creating cube it show deployment as success but while processing cube below exception occurs.

OLE DB error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.

Answer 1

Your SSAS service account doesn't have permissions to access warehouse DB. You can either explicitly set data source credentials in cube's data source or grant database permissions to NT Service\MSSQLServerOLAPService in MSSQL.