web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Failed to create a ses...
Microsoft Dynamics AX (Archived)

Failed to create a session, confirm that the user has proper privileges to log on to Microsoft Dynamics.

(0) ShareShare
ReportReport
Posted on by Muthusamy 4

Hi All,

While trying to synchronize the database for AX 2012 R3 with SQL server, we are receiving an error 

"Failed to create a session,  confirm that the user has proper privileges to log on to Microsoft Dynamics".

we are using "admin" user for synchronization process and the user having full access to the Database.

We have tried below steps, 

1. Deleted the .AUC files and restarted the AX service.

2. Deleted the .XppIL files and restarted the Service.

3. Generated the Incremental CIL and tried to synch the DB.

But no luck. Any help?

Thanks,

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    You have rejected new client sessions on the AX AOS instance in the online users form. Certain processes require additional threads and sessions to be created, DB synchronization is one of them I believe. Try allowing in additional sessions and do synchronization like that.

    If that is not the case, then have a look at your Stored procedures in the AX DB and _model DB within SQL Server and compare it against a working environment, to see if any functions are missing (createserversessions, createclientsessions, etc.).

    If you want to lock out users, you could do some changes to your application, refer to my blog on how to terminate AX sessions during startup:

    www.daxrunbase.com/.../ax-clients-with-an-outdated-kernel-executable-version-scom-blocking

    I have created a Maintenance flag on the AOS properties screen that I turn on during the Production code release, and block not just wrong client kernels, but users who do not have administration privileges too.

  • Suggested answer
    Solozmar Profile Picture
    Solozmar 796 on at

    You mention the account "admin" has DB access.  Do both AX accounts, Principle (account running the AOS) and BC account have AX access as well? 

    Also, is this a newly created or reset environment?  Is the system service account set in the System Administration module the correct account?

  • Muthusamy Profile Picture
    Muthusamy 4 on at

    Hi Vilmos & Solomon,

    Thanks for the response.

    We have only one user "Admin" having full rights for AOS and. Also both are in the same server.

    Initially, while doing DB synchronization, system showed synch failed for two table. Because of some duplicates in the standard table and having one primary unique index. we found some records are created in that table with null index value (empty).

    we deleted those null records from the table and we put synchronization again.

    After that, system started to show error "Failed to create a session,  confirm that the user has proper privileges to log on to Microsoft Dynamics".

    Initially it starts synch successfully, after some time (20-30 mins), it throws the error.

    Admin user having full rights and same user mapped with system service accounts.

    AX service is running with the admin user privileges.

    In DB side, we gave full permissions to all related Databases and stored procedures.

    Thanks,

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    That's fine, but did you verify if you are actually not missing any of those stored procedures? Compare it against a Demo VM.

    Also try emptying the SysClientSessions table while the AOS is stopped.

    Finally, remove your *.AUC files from your user profile where the AX client is running, to ensure that you have no old AOT objects in the cache.

  • Muthusamy Profile Picture
    Muthusamy 4 on at

    Hi Vilmos,

    We have checked the stored procedures with compare to another working instance. It looks like everything is available.

    Also, we have cleared the AOT objects cache data, stopped the AOS, deleted the sysclientsessions table data and deleted the .AUC files and tried to do synchronization. but no luck again same error.

    Thanks,

  • Suggested answer
    Ajit Profile Picture
    Ajit 8,788 on at

    Is this issue specific to an admin ? I mean did you try with any other admin account? Can you try with the same account you are running AX service? And also check event viewer if you can find something there.

  • Muthusamy Profile Picture
    Muthusamy 4 on at

    Hi Ajit,

    It's a new environment, currently we have only one user access and that is "Admin" only.

    Yes, AX service is running with the same user.

    Yes, we have checked that event viewer, but there is no specific information related to sync error.

    Thanks,

  • Riaz Ahmad Profile Picture
    Riaz Ahmad 104 on at

    Can you please let me know how did you solve above issue? I'm also facing same issue and did try with all possible solutions proposed in blogs.

  • Ajit Profile Picture
    Ajit 8,788 on at

    Is this happening with your Prod or Non -Prod Instances?

  • Suggested answer
    Muthusamy Profile Picture
    Muthusamy 4 on at

    Hi Riaz,

    Check whether the particular user is imported in AX and check the UserInfo table whether the particular user have imported and mapped with correct SID.

    Also, check whether C Drive have memory space to allocate memory for user login.

    Thanks,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 44

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans