Microsoft Dynamics AX (Archived)

after backup my database i got this message error

(0) Share

Report

Posted on by DMW

hi there i'm beginner here after restore my backup to sql server i got this message when i try to open AX2012

"the server is unavailable. check your configuration and network connection and try again"

and also i can't start "Microsoft Dynamics AX Object Server" how can i solve this problem pls

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (2)

Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

clearly a case, where references are still from Old DB backup and service cannot be started with current network credentials.

Remember database restore is much more than Copy Paste.

Kindly write following query on SSMS and fix references

select ID, SID, NETWORKALIAS,NETWORKDOMAIN,COMPANY, * from USERINFO

WHERE ID='Admin'

Observer result of query and update those

Was this reply helpful? Yes No
Victor Tang 47 on at

Like (0)

Report

Check event viewer from the AOS host to see what may the the issue. It could be the AOS running account does not have right to access the restored database.

Was this reply helpful? Yes No
Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report

is SQL Server is restored successfully are you able to open it in sql server ?

Was this reply helpful? Yes No
Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report

if its up then update configuration:

select distinct(KERNELBUILD) from SYSSETUPLOG

"get SID using Whoami /user

update userinfo set SID='<SID>', Networkdomain = '<Network_domain_name>', networkalias = '<Network_alias>' where id = 'admin'"

You can get SID from Command window using Whoami /user

Was this reply helpful? Yes No
DMW on at

Like (0)

Report

first thx all for reply
about databse yes i'm sure from SQL Server is restored successfully and also i can open it in sql server too

but about update USERINFO how i know my SID to update

and this pic about event viewer i didn't understand it

Was this reply helpful? Yes No
Suggested answer

Victor Tang 47 on at

Like (0)

Report

As mentioned earlier, have you checked the AOS service startup account have access to the SQL database? You need to assigned the following roles to the service account:

• db_ddladmin

• db_datareader

• db_datawriter

Was this reply helpful? Yes No
DMW on at

Like (0)

Report

i do it but still can't start AOS service

and i got this error on event

"The Microsoft Dynamics AX Object Server 6.0$01-MicrosoftDynamicsAX service terminated with the following service-specific error:

Cannot create another system semaphore."

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Microsoft has explained it well, here, although they explained at time of version 4 of AX.

unfortunately you are just telling "There is problem" without motioning what you have done so far.

have you updated user credentials?? If yes? what query you wrote? are you bringing data backup from another domain or form same domain? have you got sid of current admin account for aos service?

Was this reply helpful? Yes No
DMW on at

Like (0)

Report

no i didn't updated user credentials

and i bringing data backup from same domain

and yes i have sid for current admin

Was this reply helpful? Yes No
DMW on at

Like (0)

Report

i think i need update my AX where can i find Hotfix-KB2828720-Extensions for ax 2012

Was this reply helpful? Yes No