Sunday, May 1, 2011

AX Service start error, SQL diagnostic error.

When a new database is installed for an existing application instance, sometimes new does not have get configured properly and following error is shown, when AOS is started, in the event viewer .

Error ---
SQL diagnostics: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.. Connect information was: Userid = [], Database = [CN_Dev1], Server = [MDT753], DSN = [], Other = []
Object Server 01: Server main session is being destroyed.
Object Server 01: Fatal SQL condition during login. Error message: "[Microsoft][SQL Native Client][SQL Server]Login failed for user 'NT AUTHORITY\NETWORK SERVICE'."
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

Resolution /Cause --
If it is a new database then check the user in security node, there must be some user that is missing from the list.Usually the users that syatem should add are network service & the machine-name$. If the users are not there, add these users in security node and in schema list.
While adding user in the user list, In new user window -> Securables page add two Stored procedures "CREATESERVERSESSIONS" & "CREATEUSERSESSIONS"  that is responsible for Server session and User Session. These can be found using search option and adding the two. Also provide execute permission on them. If this step is not taken then the AOS will not start.

1 comment:

  1. dear sir ...
    i am getting below error please give me resolution
    1)Object Server 01: Dynamics Server has been stopped
    2)Object Server 01: Destroying cache objects for the main session.
    3)Object Server 01: Exiting kernel types for the main session.
    4)Object Server 01: Destroying user session with ID 1.
    5)Object Server 01: Server main session is being destroyed.
    6)Object Server 01: Uninitializing the main session.
    7)Object Server 01: Deleting label synchronizer for the main session.
    8)Object Server 01: Destroying offload table object.
    9)Object Server 01: Destroying global crypto object.
    10)Object Server 01: Destroying user sessions.
    11)Object Server 01: Exiting main session with 100 exitcode.
    Object Server 01: Server terminated unexpectedly with 100 exitcode.