Exception occurs while processing SSAS cube

133 Views Asked by At

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.

1

There are 1 best solutions below

1
On

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.