Role Center can't access AX initial database

Greetings,

After installing SP and EP.

From AX when I open the Role Center from System Administrator => User Profiles and then View Role Center. It give following error:

An unhandled error has occured. To vide details about this error, enable debugging in tehweb.config file or
view the windows event logs.

Event log as follows :

An unhandled error has occurred. To view details about this error, enable debugging in the web.config file or view the Windows event logs.

Either the user, domain\axadmin, does not have access to the Dynamics AX initial database, or the database does not exist.

Microsoft SQL Server 2014 Analysis Services

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.AnalysisServerHelper.FillTable(DataTable table, IDbCommand cmd)
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.AnalysisServerHelper.ExecuteQuery(String mdxQuery, IEnumerable`1 userParameters)
at CustCashInflowvsCashOutflow.GetCompanyAccountingCurrency()
at CustCashInflowvsCashOutflow.SetDefaultReportParameterValues()
at CustCashInflowvsCashOutflow.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Hello,

connect to analysis database and give proper rights for axadmin.

Analysis Server > Properties > Security.

We already added the user domain\axadmin into that security window

did you follow the default cubes process steps and creation of project using wizard for analysis?

technet.microsoft.com/…/dd309683.aspx

Dear All,

Solving issues one by one…
Finally it was holding in creating Analysis Project Deployment.
Later got to know the issue is with the 3rd party application for HR and Payroll which has compilation errors stopping us from Role center display.

Yday removed that solution model from isv layer…and then recompiled and then tested…its working.

So, told the client to followup with that company to fix those errors then I will try Analysis Service Project Deployment.

regards