Error in test data transfer tool

(0) Share

Report

Posted on by Muhil

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)

All responses (10)

Answers (4)

Sort by

Verified answer

Martin Dráb 239,387 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Muhil 15 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Martin Dráb 239,387 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

And what do you use for server name?

Was this reply helpful? Yes No
Muhil 15 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Muhil 15 on at

Like (0)

Report
Copy link

Link copied!

What kind of user account should be used?

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Muhil 15 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,387 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
TOMK@ida 10 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No