Just resolved a basic error with my functional team mate Qamar Zaman Khan. We both were online, Qamar for reproducing the error. Basically our cube processing was failing with the error, 

OLE DB or ODBC error: Login failed for user 'Domain\UserName$'.; 28000

I checked the cube and it had the wrong impersonation settings. I googled and found the issue hence echoing the same to all :D


In my case, the sql server analysis service login account was set local account which I think is not a good practice. And as default, the impersonation account is set to service account. Due to this, the impersonation was not working since local account (rendered as Domain\) did not had the required accounts on sql as a login. I provided a sql domain account and the error dissappeared :D. Snapshots for your reference


Post a Comment