Recently, we had a database restore of AX and when we were trying to start the AOS Service we ran into this error:
Problem:
Object Server 02: Internal Error occurred executing stored procedure when creating session for the AOS.
Solution:
After some troubleshooting found that our restored database were missing tables like SYSSERVERSESSIONS, SYSCLIENTSESSIONS & also some system stored procedures were missing.
i definitely love your own writing kind, very useful.
ReplyDeletedon't give up as well as keep writing seeing that it simply worth to read it.
impatient to find out additional of your current content, kind regards :)
How did you resolve this issue? I think it has something to do with moving DBs and restoring backups. All of the MS documents I see say that the AOS service user needs to be db_ddladmin, db_datareader, and db_datawriter and the user needs to have execution writes on createserverssessions and createusersessions stored procs. That should fix it. Try setting the AOS user as owner of the DB too.
ReplyDeleteTo resolve, locate these procedures in SQL, right-click, go properties, then add the database user and give permission for them. This will solve.
ReplyDeleteI tried to recreate the stored procs but there were already there so I updated my aos security account as dbowner and it fixed it. This is only my development environment so I don't need to get it exactly right as long as it works!
ReplyDelete