I was trying to deploy the a cube into Analysis Services DB, present in a different server from my development machine (BIDS) and this is the first among many errors i got.
OLE DB error: OLE DB or ODBC error: Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.; 28000.
Took a look at my data sources, and on the impersonation tab, i played around with the different options available. I had set it to "default" and i was able to deploy to the localhost. Now i tried all the other options like “Use the credentials of the current user” but got errors.
I have found that “Use a specific user name and password” works. But i tried to specify a username and password thinking it will assign this specifically to the cube, but again errors. I found out that it is actually expecting for the windows user name and password. So in my scenario it works well when i gave my windows authentication - domain/username and then password.
