Tuesday, April 5, 2011

Error while deploying a copy of a cube 'OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.; 28000.'

In Analysis Services 2008-R2, there are several impersonation options:

•Use a specific Windows username and password
•Use the service account
•Use the credentials of the current user
•Inherit (or default)

Try Out below things
1-Error implies impersonation info on connection string, security context failes.
Check for the service account on test server, and under impersonation info put service account.

2- Processing manually from SSMS and see if you get the same error or not.

3- You can go through these steps:
-Ensure that there is nothing deployed to your SSAS instance
-Open the project in BIDS Application
-Check project to make sure you are deploying to the right server
-Data Source - is it pointing to the correct location and does Test Connection succeed?
-Check the Impersonation Information tab and make sure that the option there will work for SSAS to connect to the database server - as in there is a login for the option
-Click on process and see if the solution gets deployed properly
-Process Cube

Posted by - SUHAS R. KUDEKAR (MCTS - Microsoft Business Intelligence)
Learning Office 2010 + SharePoint 2010 + SQL Server 2008 R2

No comments:

Post a Comment