If you are deploying/building a cube in SQL Server Analysis Services (SSAS), and you get tons of errors, and littered throughout you see
OLE DB error: OLE DB or ODBC error: Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’.; 28000.
You should take a look at your data sources, and on the impersonation tab, play around with the different options. Usually it is set to “Use the service account” or “default”. I have tried “Use the credentials of the current user” but got errors back when deploying saying that the impersonation method was invalid for processing. I have found that “Use a specific user name and password” works. As I sit and wait for the cube I just finally got to deploy to finish, I figured I would write this up in a post. Your mileage may vary.
Steve Novoselac's Blog 
19 replies on “SSAS: Deploying Cube OLE DB Error – Login Failed”
Hi Steve,
Nice post,i also had same problem and this article helped me to resolve it. thanks a lot..hv a grt time !
LikeLike
Props Steve!
This was killing me in figuring out how to get around this error. The “use a specific user name and password” worked. I will add for others finding this post, however, that the user name should be the windows username and not SQL server’s. So, you’ll want:
username=
Thanks again!
LikeLike
Thanks, thanks and thanks again. I was near a total melt-down in my head. Combining Steves and your post saved me from going totally crazy!!
LikeLike
Hi …
Try to run the service as a user who has at least read access to the reporting database. …
check the link:
http://technet2.microsoft.com/Office/en-us/library/2c87fa4b-5893-441b-af01-eca949bf52a81033.mspx?mfr=true
LikeLike
Thanks a lot, very good post…i had the same problem and it worked for me.
very helpful article…Thanks again.
LikeLike
Cheers, it worked for me as well.
LikeLike
Thanks much – this worked for me too. Earlier, I tried changing permissions for NETWORK SERVICE from inside SQL Server Management Studio, but that didn’t do it.
LikeLike
Thank you! I encountered the same problem, previously I only tried using current user, but the error still existed, then I specified the username and it worked, though it was just the current user.
LikeLike
Nice one
LikeLike
Hi Steve,Thanks for the post. It works for me.Thanks
LikeLike
thanks for the info… some added detail though..you get to the impersonation tab via opening the Datasource designer window, or via double-clicking on the data source on the project list.I originally tried the properties of the datasource and couldnt find it there.
LikeLike
I got this error today. Your blog helped lead me to the root of the issue (the data source). The problem with mine, however, is that my data souce was pointing to a different server than the one that I was performing the Process on.
LikeLike
I have the same erreur and I didn’t know how t solve it can any one help me please !!!
LikeLike
Try changing the SSAS service running Local System account and then build the Analysis Services project from Business Intelligence studio.
LikeLike
Try changing the SSAS service running Local System account and then build the Analysis Services project from Business Intelligence studio.
LikeLike
I can confirm that using a specific username/password worked for me as well. Thanks!
LikeLike
nice one, worked when i specified a user account, didn’t work on the other options..
LikeLike
Thanks, changing my settings to username and password worked well for me!
LikeLike
thanks
LikeLike