Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Configuring Dynamics AX 2009 to use user accounts instead of a service account for transactions to the database

Posted on by Microsoft Employee

Hi, do you know if there is a way to configuring Dynamics AX 2009 to use user accounts instead of a service account for transactions to the database (in a Windows Server domain environment)?

Currently we are facing the situation when multiple transactions and AX batchjobs blocks each other (headblocks) even when there is an RCSI set on the SQL Server of AX 2009 set. And we are not able to differentiate the transactions of particular users and AX BatchJobs on the SQL level as they all used the AX service account to connect to the database. Troubleshooting of which user transaction or which AX BatchJob is causing the issue is not possible. Any suggestions are more than welcome. Yes, I know the AX2009 is old but we cannot upgrade it now.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Configuring Dynamics AX 2009 to use user accounts instead of a service account for transactions to the database

    Thank you very much for your response, I'll check it.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: Configuring Dynamics AX 2009 to use user accounts instead of a service account for transactions to the database

    It's not possible. All connections to database are done by AOS (and therefore using the AOS service account), not by end users.

    Enabling SQL tracing in AX and/or using ETW/Trace Parser may help you with correlation. Note that tracing has certain overhead, therefore you shouldn't keep it enabled when you don't need it. Here is another resource you might find useful: Tracing in Dynamics AX 4 and 2009.

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Configuring Dynamics AX 2009 to use user accounts instead of a service account for transactions to the database

    It's not possible to use user accounts instead of service accounts. But in the blocking info in SQL you should see SPID and you can see that in Online users form in AX as well.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans