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 / Microsoft Dynamics AX (Archived) / cannot execute the req...
Microsoft Dynamics AX (Archived)

cannot execute the required database operation. The SQL databse has issue an error

(0) ShareShare
ReportReport
Posted on by Jason Tang 65

Hi,

I'm new in this forum. I come accross an error message "cannot execute the required database operation. The SQL databse has issue an error" when I want to post shipment for transfer order. I'm using AX 2009. How do I solve this?

Base on the previous similar subject dated in February, I need to look into the Event Viewer for both SQL and Windows. I've check the Windows application event viewer and found out that there are a lot of similar error message

"login failed for user sa"

and one of this message below

"SQL Server Scheduled Job 'Process EVP Sales Analysis Cube and Related Dimensions' (0xD383D111FAE64647B3C335215E37FC43) - Status: Failed - Invoked on: 2012-04-13 05:00:00 - Message: The job failed.  The owner () of job Process EVP Sales Analysis Cube and Related Dimensions does not have server access."

Can any enlighthen me on this issue?

*This post is locked for comments

I have the same question (0)
  • Gert Raangs Profile Picture
    Gert Raangs 265 on at
    Re: cannot execute the required database operation. The SQL databse has issue an error

    Is it possible that the person who has created the job, does not have enough permissions to execute ?

    Because of the message : "The owner of the job".. Who is the owner.. does this one have enough permissions (SQL Login perhaps ?)

  • Jason Tang Profile Picture
    Jason Tang 65 on at
    Re: cannot execute the required database operation. The SQL databse has issue an error

    Hi Gert,

    The SQL Agent is running locally in the server so it has full permission to execute procedures.

  • Jason Tang Profile Picture
    Jason Tang 65 on at
    Re: cannot execute the required database operation. The SQL databse has issue an error

    Hi Phillippe,

    I've tried synchronize table. There were 4 error messages of "cannot execute a data definition command language on (). The SQL database has issue an error". Synchronize failed on 4 tables.

  • Gert Raangs Profile Picture
    Gert Raangs 265 on at
    Re: cannot execute the required database operation. The SQL databse has issue an error

    Does the SQL Server agent has enough permissions to execute procedures ? Try adding the role sysadmin to the sql server agent account....

  • Philippe VS Profile Picture
    Philippe VS 185 on at
    Re: cannot execute the required database operation. The SQL databse has issue an error

    Can you perform a synchronise on the database?

  • Jason Tang Profile Picture
    Jason Tang 65 on at
    Re: cannot execute the required database operation. The SQL databse has issue an error

    The messages are from AOS server's event viewer. I'm using the administrator password, but  still face the same error message.

  • Philippe VS Profile Picture
    Philippe VS 185 on at
    Re: cannot execute the required database operation. The SQL databse has issue an error

    Jason,

    Did you check the event viewer on the AOS server as well? The user who executes the AOS has the according priviliges on the SQL Database?

    Based on your findings:

    - the login for the sa user is wrong in some application

    - Problem with the role center cubes

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans