This is one I should have written down a long time ago…
When setting up a new database for AX 2012 and I am trying to start the service I am getting the following error:
Internal Error occurred executing stored procedure when creating session for the AOS.
The reason for this is that AX is looking for two Stored Procedure in the AX database called CREATESERVERSESSIONS and CREATEUSERSESSIONS. If these are missing the service will not start. My temporary solution is that I script out the SPs from another database and create them where they are issing.
Johan
Links:
http://dynamics-ax-live.blogspot.com/2009/04/missing-stored-procedures.html