still Cannot connect to analysis server error after all the Kerberos Configuration

Once we implement the Enterprise Portal installation and Kerberos Configuration for the whole Microsoft Dynamics AX 2009 environment, we still faces the similar issue as Kerberos issue: cannot connect to the analysis server.

It is in Windows 2008 R2 version.

If we check the event log, the error message in the Application log is in the beneath:

An unexpected error has occurred.

Authentication failed.

Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Authenticate(ConnectionInfo connectionInfo, DateTime startTime)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Microsoft.Dynamics.Framework.Portal.UI.WebControls.WebParts.BusinessOverviewWebPart.InitConnection()

No credentials are available in the security package  (The one is not the same as Kerberos authentication issue)

System.ComponentModel.Win32Exception
   at Microsoft.AnalysisServices.AdomdClient.CredentialsContext..ctor(String package, CredentialUse intent)
   at Microsoft.AnalysisServices.AdomdClient.NTAuthentication..ctor(ConnectionInfo connectionInfo)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Authenticate(ConnectionInfo connectionInfo, DateTime startTime)

The Solution is very easy. Run the IE using Run As Administrator (Even you turn off the UAC) and open the EP site. Once you see the KPIs, you can close the IE and open it in the normal way. The KPIs error in the EP and AX can be fixed then.

Advertisements
This entry was posted in Microsoft Enterprise Portal. Bookmark the permalink.

One Response to still Cannot connect to analysis server error after all the Kerberos Configuration

  1. portal says:

    Thanks for finally talking about >still Cannot connect to analysis server error after all the Kerberos Configuration | Microsoft Dynamics
    AX <Loved it!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s