Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Error Contoso Demo Data Import to Dynamics AX 2012 R3

Posted on by Microsoft Employee

Hi All,

 My AOS server and sql server are not in same server and  i tried to import  contoso demo data to Dyanmics AX 2012 R3 by using Test Data Transfer Tool (beta) but end of process i got that error and i could not import contoso demo data as you see below photo.

I wrote my problem  here a few times and some of them told me that i should run cmd  as administrator but i already tried it and it didnt work.

Do you have another advice? What should i do?

8233.LastError.PNG

Best regards

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error Contoso Demo Data Import to Dynamics AX 2012 R3

    Hey u need to provide DB server name if DB in different server like below

    DP.exe IMPORT "C:\DynamicsAXR3DemoData" DatabaseName Servername

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error Contoso Demo Data Import to Dynamics AX 2012 R3

    Hi Kintera,

    I would tried it before you said but it didnt work that's way i put third question to explain my situation  well. Anyway thank you  for  your helping.

    Best regards

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error Contoso Demo Data Import to Dynamics AX 2012 R3

    Hi Calavon,

    Sorry  duplicate question but  i realized on  first  and  second questions that i couldnt explain my situation  very well and i put third question and explained it well.

    Everybody who answered  told almost  same that i must  run cmd as administrator but it didnt work.  

    Then, i installed TDTT in server  where is sql server database of Dynamics AX   and i imported contoso demo data as you said in your last comment .  Then  problem was solved.

    Next time, i am gonna explain my situation very well and i am not gonna put duplicate question.

    Thanks for your helping.

    Best regards

  • Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Error Contoso Demo Data Import to Dynamics AX 2012 R3

    I gave the exact same suggestion, but caner seems to just ignore it. I believe that is the key to resolve this access rights issue indeed.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,219 Super User 2024 Season 2 on at
    RE: Error Contoso Demo Data Import to Dynamics AX 2012 R3

    I have merged 3 questions now...

    When I look at your screenshots I noticed you haven't run the command prompt in Administrator elevated rights. The title of your window starts with "Command prompt". When run it as administrator it should mention: "Administrator: Command prompt". Make sure you right click the Command prompt tile and select "Run as administrator".

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,219 Super User 2024 Season 2 on at
    RE: Error Contoso Demo Data Import to Dynamics AX 2012 R3

    Hi Caner,

    I noticed you have created some duplicate questions on this forum. I will try to merge them as moderator. In future please don't create duplicates as you are then wasting time of moderators which have less time available to also answer questions.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,219 Super User 2024 Season 2 on at
    RE: Error Contoso Demo Data Import to Dynamics AX 2012 R3

    Hi Caner,

    What exact command did you use to import the demo data? Have you also tried to use the TSTT on the SQL server itself instead of using it on the AOS machine?

    SQL client tools needs to be installed on the machine where you use the TDTT.

    More help for installation of the TDTT can be found here: ax.help.dynamics.com/.../install-the-test-data-transfer-tool-beta-for-microsoft-dynamics-ax

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error After Imported Contoso Demo Data in AX 2012 R3

    Firstly, thank you to answered

    What you mean exactly? Could you explain it more?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error After Imported Contoso Demo Data

    Thank you to answered my question but i treid it before.

    Do you have another suggestion?

  • Suggested answer
    nunomaia Profile Picture
    nunomaia 10,684 Super User 2024 Season 1 on at
    RE: Error After Imported Contoso Demo Data

    Try to run the tool as local administrator

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans