Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Management Reporter - Confiure AX 2012 Data Mart Error

Posted on by 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

  • Trung Nguyen Profile Picture
    Trung Nguyen 1,245 on at
    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 Profile Picture
    Thomas Madden 65 on at
    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
    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 Profile Picture
    Thomas Madden 65 on at
    Re: Management Reporter - Confiure AX 2012 Data Mart Error

    Receiving the same error as well.  Anyone with further suggestions ?

  • Trung Nguyen Profile Picture
    Trung Nguyen 1,245 on at
    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 Profile Picture
    Ajit 8,755 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans