Microsoft Dynamics AX (Archived)

Management Reporter - Confiure AX 2012 Data Mart Error

(0) Share

Report

Posted on by Trung Nguyen

1,245

Hi all,

I'm getting this error while configuring AX 2012 Data Mart:

1/9/2013 9:59:53 AM - Application service URI is http://sqlserver:4712/
1/9/2013 9:59:53 AM - Configuring Dynamics AX adapter with settings: AOS: aossever:2712, AX Services Port: 2712, User: Contoso\Administrator, Database: ContosoAX2012, SQL Server: sqlserver
1/9/2013 9:59:53 AM - Configuring data mart adapter with settings: Server: sqlserver, Database: DDM_ContosoAX2012, User name: , Windows auth: True, Encrypt connection: False
1/9/2013 9:59:54 AM - Logon Failed - Logon failure: unknown user name or bad password
1/9/2013 9:59:54 AM - Rolling back data mart database creation due to installation error. Connection information:
Create new database: True
Server name: sqlserver
Database name: DDM_ContosoAX2012
Integrated authentication: True
Encrypted connection: False
1/9/2013 9:59:54 AM - The data mart database was rolled back successfully.
1/9/2013 9:59:58 AM - Microsoft.Dynamics.Performance.Deployment.Console.Core.DeploymentFailedException: The settings for the Dynamics AX 2012 connection are not valid. Check the deployment log for details.

   at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AX2012DataMartDeploymentPart.ValidateIntegration(IDictionary`2 settingsToDeployWith)
   at Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012.DataMart.AX2012DataMartDeploymentPart.DeployWithSettings(IDictionary`2 settingsToDeployWith)
   at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.DeploymentViewModel.TryRemoveFromView(Boolean isProgressing)

I make sure I have entered correct username and password but the Error said that "Logon Failed - Logon failure: unknown user name or bad password".

Does anyone face this issue? Please give me an advice.

Thanks in advance.

Additional information:

1. I'm setting up AOS and Database of AX 2012 on seperate server (named AOSServer and SQLServer in turn).

2. Both server using Windows Server 2008 R2. SQLServer using SQL Server 2008 R2

3. Management Reporter Server is installed on SQLServer.

4. Windows firewall is turned off on both server.

*This post is locked for comments

All responses (6)

Answers (1)

Trung Nguyen 1,245 on at

Like (0)

Report

RE: Management Reporter - Confiure AX 2012 Data Mart Error

Hi Ryan,

Thank you so much.

I configure with another account and everything is perfect.

BR,

Trung
Suggested answer

Thomas Madden 65 on at

Like (0)

Report

Re: Management Reporter - Confiure AX 2012 Data Mart Error

Ryan, As you suggested using a different user account other than Administrator proved successful. Thanks for the Tip!
Verified answer

Ryan Sandness on at

Like (0)

Report

Re: Management Reporter - Confiure AX 2012 Data Mart Error

I've seen some issues where the Administrator user is used in a multi-tier environment. I'd suggest you try the following:

1. Create a dedicated service account in Active Directory like contoso\mr_svcact

2. Verify that user has 'disable password expiration' enabled and has a valid display name in Active Directory

3. Setup the mr_svcact with the security administrator and system administrator roles in Dynamics AX.

4. Setup mr_svcact as a SQL Server login with Windows Authentication. Grant that user db_datareader for the AX database and the AX_model database (if AX 2012 R2).

4. Install MR in two stages. First deploy an application and process service using mr_svcact as the service user. Contoso\Administrator can be your first MR admin if creating a new database.

5. Configure AX Data Mart logged in as contoso\administrator but using contoso\mr_svcact as the integration user.

That hopefully should resolve the issue. Normally you wouldn't need to give the mr_svcact so many permissions in a production environment, but I want to avoid the use of the contoso\administrator account as I believe that is a partial source of the issue.

Thanks

Ryan
Thomas Madden 65 on at

Like (0)

Report

Re: Management Reporter - Confiure AX 2012 Data Mart Error

Receiving the same error as well. Anyone with further suggestions ?
Trung Nguyen 1,245 on at

Like (0)

Report

Re: Management Reporter - Confiure AX 2012 Data Mart Error

Hi Ajit,

I have full right in SQL Server. All information are correct.

do you have any ideas?
Ajit 8,755 on at

Like (0)

Report

Re: Management Reporter - Confiure AX 2012 Data Mart Error

Hi Trung,

Do you have access sysadmin rights in SQL server which you have giving for DATA Mart DB? and Make sure you are giving correct AOS information and port numbers.