Problem description
The following error message appears when you try to use SSAS for OLAP in the official Microsoft Tutorial:
Severity Code Description Project File Line Suppression state
Error OLE DB errors: OLE DB or ODBC error: Login failed for user ' NT service\mssqlserverolapservice '.; 28000. 0
Cause of the problem
This issue occurs because of an authorization authentication error when connecting to a SQL Server data source.
Solution Solutions
- Open SSMs
- Find Security/login Festival
- Add "NT service\mssqlserverolapservice" account
- Right-click to open the "NT Service\mssqlserverolapservice" Account property
- Find "User Mapping"
- Find the database you want to associate on the right, this is "AdventureWorksDW2012"
- In the bottom right of "Database role membership for:adventureworksdw2012", tick "db_datareader" "db_datawriter"
- Click "OK"
- Re-deployment, success
Related illustrations
1. Data Source Property →impersonation information→ Set "Use the service account"
2. Data source properties → Click edit→ to configure the DataSource provider for Native OLE db\sql Server Native Client XX. X
3. Open ssms→ Follow the steps described in the solution to configure
Ssas:ole DB error: OLE db or ODBC error: Login failed for user ' NT Service\mssqlserverolapservice '