Clever Geek Handbook

An exception occurs while processing an SSAS cube

when creating the cube, it shows the deployment as a success, but when processing the cube, there is an exception below.

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

+3


source to share


1 answer


Your SSAS service account does not have permissions to access the warehouse database. You can either explicitly set the data source credentials in the cube data source, or grant database permissions to the NT \ MSSQLServerOLAPService service in MSSQL.



0


source






More articles:


All Articles