You’re offline. This is a read only version of the page.
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
Hi Ryan,
Thank you so much.
I configure with another account and everything is perfect.
BR,
Trung
Ryan, As you suggested using a different user account other than Administrator proved successful. Thanks for the Tip!
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
Receiving the same error as well. Anyone with further suggestions ?
Hi Ajit,
I have full right in SQL Server. All information are correct.
do you have any ideas?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (