daxdilip: Dynamics AX Troubleshooting AOS Error Internal Error occured executing stored procedure when creating session for the AOS

[Blog bot]

Источник: http://daxdilip.blogspot.com/2010/12...aos-error.html
==============

Issue

One of our AOS suddenly stopped working and it won't restart any more. Learned that there was a database refresh the last night.

The error I found in event viewer was Object Server 01: Internal Error occured executing stored procedure when creating session for the AOS (Screenshot below)

Solution

After some troubleshooting, found that the service account used by AOS somehow lost the db_owner rights on the database and the error above makes sense as the service account no longer can create the server and client sessions and hence it won't start. After giving back the rights to the account, the service started without any issues. (Screenshot below for giving the service account rights to db_owner permissions via SSMS)

Источник: http://daxdilip.blogspot.com/2010/12...aos-error.html