Home > X++ stuffs > Error occurred executing stored procedure when creating session for the AOS

Error occurred executing stored procedure when creating session for the AOS

 

Please Note:  All this code snippets are a result of some development that came up from time to time. Please feel free to use them for your own use with discretion.

 

In AX2009 I tried manually creating DB and pointing Dynamics server to the created DB. When trying to start the AX services I ended up facing following errors.

err100.jpg

 

On viewing the event viewer under Application you will clearly see there is a login failure issue

even.jpg 

So you need to manually change the log on password under Dynamics AX service properties. Again when AX service was restarted there was another error.

err100.jpg

 

In the event viewer you’ll see the following error

eves.jpg 

What is the error all about?

When AX is installed through setup.exe, stored procedures are internally created for the Database. The two stored procedures that gets created are

·         CREATESERVERSESSIONS

·         CREATEUSERSESSIONS à This creates the User Session

So when DB is created manually in SQL, the stored procedure is not available because of which AX service is not started successfully.

 

Solution:

For the DB which are created manually make sure you create the stored procedure successfully in order to point to AX server.

 

STORED PROCEDURE FOR CREATESERVERSESSIONS

http://cid-264a0056cbcbb1d3.skydrive.live.com/self.aspx/.Public/CREATESERVERSESSIONS.sql

 

STORED PROCEDURE FOR CREATEUSERSESSIONS

http://cid-264a0056cbcbb1d3.skydrive.live.com/self.aspx/.Public/CREATEUSERSESSIONS.sql 

 

Run the stored procedure SCRIPTS and then try to restart AX service. You’ll successfully be able to point to the newly created Database.

Advertisements
Categories: X++ stuffs
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: