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 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.
Simlar Posts
- SSAS: Errors in the metadata manager. The dimension with ID of…
- 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
