SSAS: Deploying Cube OLE DB Error - Login Failed
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 AUTHORITY\ANONYMOUS 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.
Simlar Posts
- SSAS 2005: Cube Perspectives Are Good, But Something Is Missing…
- SSRS and SSAS Formatting Dates
- How To: Connect to SQL Server, VS TFS, etc using Windows Authentication when computer is not on Active Directory Domain (XP and Vista!)
- SSAS: AverageOfChildern and Semi-additive measure requires a time dimension
- SSAS Cubes - Speeding up Queries and Performance
August 14th, 2007 at 3:31 am
Hi Steve,
Nice post,i also had same problem and this article helped me to resolve it. thanks a lot..hv a grt time !
January 3rd, 2008 at 11:32 am
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!
February 27th, 2008 at 4:29 am
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