web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error in test data tra...
Finance | Project Operations, Human Resources, ...
Answered

Error in test data transfer tool

(0) ShareShare
ReportReport
Posted on by Muhil 15

Hi,

I tried to export data from AX 2012 R3 environment using Microsoft dynamics AX test data transfer tool (beta). 

I used the cmd --  DP.exe H:/ExportDP <Databasename> <servername>

Also tried with providing domain name with the server name.

But I get the error --  cannot access databases <databasename>. No database found.

The SQL is in the same server only. And the SQL version is 2016 SP2. 

But the same cmd work for me in different environments in SQL2014 version. 

Kindly help me to find a solution for this issue.

I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 236,570 Most Valuable Professional on at
    RE: Error in test data transfer tool

    I don't believe that your command can work, because you forgot to specify the direction (the first parameter saying whether it's import or export).

    Regarding "No database found", verify that the DB name is correct and you have permissions to work with it.

  • Muhil Profile Picture
    Muhil 15 on at
    RE: Error in test data transfer tool

    Sorry the cmd I used is DP.exe Export H:/ExportDB <Databasename> <servername>

    And the DB name and server name is correct. I have admin access.

  • Martin Dráb Profile Picture
    Martin Dráb 236,570 Most Valuable Professional on at
    RE: Error in test data transfer tool

    What kind of admin? U user with sysadmin role in SQL Server, for instance?

    And what do you use for server name?

  • Muhil Profile Picture
    Muhil 15 on at
    RE: Error in test data transfer tool

    We tried using server admin. And for the server name we used just the server name (T-DBDEV1)

  • Muhil Profile Picture
    Muhil 15 on at
    RE: Error in test data transfer tool

    What kind of user account should be used?

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: Error in test data transfer tool

    You need to provide the SQL Server instance name too along with the server name. At least if the instance has some other than the default name. So in the db server parameter you would pass something like myServer\myInstance.

  • Muhil Profile Picture
    Muhil 15 on at
    RE: Error in test data transfer tool

    I tried that too. As it is default instance, I tried with MSSQLSERVER as instance name. But got same error.

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at
    RE: Error in test data transfer tool

    Perhaps it doesn't work with SQL Server 2016, then. You could ask MS support about it. As far as I know, the tool was never officially released so perhaps they never added support for SQL Server 2016, even though such support was added to AX itself.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 236,570 Most Valuable Professional on at
    RE: Error in test data transfer tool

    That the user account is a local admin in Windows doesn't necessarily mean that it has permissions in SQL Server to read the database.

  • TOMK@ida Profile Picture
    TOMK@ida 10 on at
    RE: Error in test data transfer tool

    Hi Muhil, 

    I have/had the same problem/error.

    This is the command that dp.exe throws at the sql server --> SELECT NAME FROM sys.sysdatabases where sid != 0x01 and version is not null AND DATABASEPROPERTYEX(name,'status') = 'ONLINE' order by crdate desc

    sid != 0x01 --> is the same as sid NOT=0x01

    The sa account on mssql always has 0x01

    So so me its looks like that the dp.exe has a block, if the <database> has SA as owner the process stops.

    If you have a test system to export from, try to change the database owner to a domain user and start the export again.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,922

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,922

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 835 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans