So after more than two years of working perfectly, one of our AX 2012 R2 servers refuses to synchronize, giving the error 'Failed to Create a Session.' None of the usual tricks worked, and the problem remains. Here are all the things we tried:
1. Restart the AOS, full compile, full CIL
2. Restart the AOS, run the partition initialization checklist (which appears to have changed nothing), full compile, full CIL
3. Manually recompiled all the system classes, followed by a full CIL
4. Ran the partition update script that most of the articles reference: 0 rows affected
5. Checked the admin user SID in the users table--it is good, there are not multiple partitions in the table
6. Just to eliminate permissions, gave NT AUTHORITY\Authorized Users sysAdmin rights on the SQL Server (and then removed the permissions, because leaving that in place would be... stupid ; )
The user logged in is an AX admin, server admin, domain admin, SQL admin, and dbOwner on the AX database and model store.
And with that, we are completely out of ideas.
Any new suggestions?
