Code Example Center: SQL SERVER - How to solve problem "OLE DB error: OLE DB or ODBC error: Login failed for user" on BI cubes processing

Friday, June 22, 2018

SQL SERVER - How to solve problem "OLE DB error: OLE DB or ODBC error: Login failed for user" on BI cubes processing

This error occurs, when user (here NT SERVICE\MSOLAP$TSTINST) have not access to source DB.

Solution: Add to user db_datareader rights.

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)