[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.;28000;Time: current date and time
Data source provider error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.;42000; current date and time
When the MSSQLServerOLAPService service is configured to run under a local or domain user account, the account must be a member of the OLAP Administrators group on the OLAP server. This will grant it permissions to access the repository, registry, and data directory on the OLAP server.
In addition to being a member of the OLAP Administrators group, the account must also have the appropriate permissions on SQL Server. The permissions required will vary depending upon the type of storage structure selected for the OLAP cube. When using MOLAP storage, the account must have at least SELECT permissions on the source database. If ROLAP or HOLAP storage is used, the account must have at least SELECT and CREATE TABLE permissions on the source database.
By changing the MSSQLServerOLAPService service to run under a domain or local user account that is a member of the OLAP Administrators group on the OLAP server and that has privileges on SQL Server, OLAP Services will be able to successfully process.
Article ID: 224973 - Last Review: Jun 12, 2008 - Revision: 1