Microsoft Dynamics AX (Archived)

Failed to update database "MicrosoftDynamicsAX" because the database is read-only. '0' 'Sales order header' record(s) inserted in staging

(0) Share

Report

Posted on by Yasir Shahzad

1,635

Dear

Following error found in DMF while Uploading Sales Order Header File

How Can i resolve it

regards

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

The error says that your database is readonly, so first logical step is checking whether it's the case or not. Open the database in SQL Server Management Studio and check if Database Read-only property is set to False.

If it's all right, then I would review user permissions.

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Yasir,

You need to check that DMF service user has write access to AX database. Recomended to have the same user as AOS service.

Also please check that DB is not in read only mode.

Was this reply helpful? Yes No
Yasir Shahzad 1,635 on at

Like (0)

Report

dear miroshnikov & Martin....i have checked the both recommendations but nothing happened

Regards

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

Like (0)

Report

How exactly did you verify that the service can write to the database? I would everything was correct, you wouldn't get the error, so something must be wrong.

You may also spend a few minutes giving us some context, such as whether your DMF service worked at some point (and what happened before it got broken) or it is a new installation, what account you use for the service and what permissions it has and so on. You can't expect us to know your situation without you writing it down.

Was this reply helpful? Yes No
Yasir Shahzad 1,635 on at

Like (0)

Report

Dear Martin....i have already worked on DMF but this error is facing 1st time...id data base i have see that the SQL studio on False...also i checked the DMF services in ax ..i restart it..also DMF parameters are valid

Regards

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

Like (0)

Report

Let me repeat a few questions:

What happened before it got broken?

What account do you use for the service and what permissions does it have?

Was this reply helpful? Yes No
Yasir Shahzad 1,635 on at

Like (0)

Report

dear martin....we are registered on Microsoft...my company has purchased license from them...i m using sys admin...before it ...i think there is compilations process started

Regards

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

Martin: The guy is a functional person with limited AX knowledge trying to do magic, and will not be able to provide the details you expect to be able to help him.

Yasir: please get a technical staff involved to answer the questions that were asked, since your reply has very less to do with what was asked. AX AOS service account, DIXF service account, SQL Server login credentials, SQL Server AX database Security credentials with associated Security roles in the DB.

Was this reply helpful? Yes No