Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Db Sync A session cannot be created error AX2012

Posted on by 3,987
I am getting this error on an AX2012 when I run Db Sync:
/A session cannot be created. Verify that the user has the necessary rights to log on to Microsoft Dynamics./

I did check the 5 points mentioned in this post: 5 Tips to Resolve the AX Error: ‘Failed to create a session; confirm that the user has the proper privileges…’ (stoneridgesoftware.com)

1. Partitions.
There is only one partition, so this should not be the issue, but I did also try to create the mentioned two other partitions, and created the required records for my under in UserInfo.

 
2. Run Business Logic
Tried Syncing with CIL Disabled, did not help.

 
3. Run a Full CIL.
Did that if completes with no errors, but I still get the error.

 
4. Delete your AUC Files.
Also did not help.

 
5. Improper Privileges
I checked and both my user and the user the AOS runs under had the prober privileges on the SQL Database.

 
So does anyone have any idea what the problem might be?
  • Verified answer
    Rudi Hansen Profile Picture
    Rudi Hansen 3,987 on at
    Db Sync A session cannot be created error AX2012
    I found the problem; it turns out that the Admin user in AX was a user that does no longer exist on the Domain.

    So, I imported the correct Admin user into AX, and with the AOS down, I removed the old user and updated the new one to have the right Id and same Recid as the old Admin user.
    That solved the issue.
  • Rudi Hansen Profile Picture
    Rudi Hansen 3,987 on at
    Db Sync A session cannot be created error AX2012
    Hi Andrew.

    No there is only one Domain.
    And as far as users, well at least I seem to have the problem with more than one user and have not seen any users that can do this.


    This environment I am seeing the problem on is a new AOS I am setting up as a replacement for their old DEV Environment.
    I do also get the same error on their old DEV env, but I have not tested on their production.


     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    Db Sync A session cannot be created error AX2012
    Hi Rudi,
     
    It is a very long time ago for me working with AX2012 and similar error messages. Do you have more than one domain in your network? Do you have the issue with all users? Is this a production or another type of environment?
  • Rudi Hansen Profile Picture
    Rudi Hansen 3,987 on at
    Db Sync A session cannot be created error AX2012
    Hi Jude.
     
    Yes the user is system administrator on AX, if that was not the case it would not even be possible to run the DB Sync.
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Db Sync A session cannot be created error AX2012
    Based on the error message, can you check if the user account used for DB sync  has the necessary permissions and privileges to access Microsoft Dynamics AX.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans