tag:blogger.com,1999:blog-3683188422603325740.post5264083710753569891..comments2024-03-06T15:46:09.045+11:00Comments on Dilip's blog on Dynamics 365 for Finance and Operations and Classic AX: Dynamics AX Troubleshooting AOS Error Internal Error occured executing stored procedure when creating session for the AOSDiliphttp://www.blogger.com/profile/16427786826205553577noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-3683188422603325740.post-27457522204664826752010-12-24T10:31:19.873+11:002010-12-24T10:31:19.873+11:00Guys, Thanks for your comments. Sorry mistakenly i...Guys, Thanks for your comments. Sorry mistakenly in my previous post I wrote that the aos service account needs db_owner permissions on the database which is not correct. Since it was a training environment, I took the liberty to give the account full permissions to the database, It can be solved by giving execute permissions for the sp's provided in my link. Happy Daxing :-)Diliphttps://www.blogger.com/profile/16427786826205553577noreply@blogger.comtag:blogger.com,1999:blog-3683188422603325740.post-91581468282171398712010-12-24T06:09:14.589+11:002010-12-24T06:09:14.589+11:00I went through this same issue last week. Glad to...I went through this same issue last week. Glad to see I'm not the only one. Great blog. We are going live with AX on Jan 1 so I've been reading this quite a bit. Keep it up!Eric Barbhttps://www.blogger.com/profile/04124674666673355058noreply@blogger.comtag:blogger.com,1999:blog-3683188422603325740.post-82647001748914212552010-12-24T02:32:17.628+11:002010-12-24T02:32:17.628+11:00This is wrong. The AOS user needs execute permiss...This is wrong. The AOS user needs execute permissions on two stored procedures. Go to your DB, then Programmability>Stores Procedures, then on dbo.createserversessoins and dbo.createusersessions, right click, properties.<br />Click on permissions, click "Search" and find the AOS user, then check "Grant" on the execute option for each stored procedure. You can argue it doesn't hurt anything to make the AOS user a DB owner though...Unknownhttps://www.blogger.com/profile/01243701103710619362noreply@blogger.comtag:blogger.com,1999:blog-3683188422603325740.post-14826100782404800632010-12-23T23:45:39.608+11:002010-12-23T23:45:39.608+11:00Apparently making AOS account the database owner o...Apparently making AOS account the database owner or sysadmin (god forbid) role member will solve the problem, but it is not required and not safe in some scenarios. The EXECUTE permission on stored procedures would be enoughVadimnoreply@blogger.comtag:blogger.com,1999:blog-3683188422603325740.post-3296754514920384472010-12-23T19:46:42.017+11:002010-12-23T19:46:42.017+11:00Wouldn't it just be sufficent to grant the ser...Wouldn't it just be sufficent to grant the service account Execute permission on the two stored procedures that create client or server sessions? That is what I do. The AOS service doesn't need to have db_owner that way.tommy.skauehttps://www.blogger.com/profile/13189067870996112658noreply@blogger.com