AOS Service not start after restore demo data CU7

(0) Share

Report

Posted on by Community Member

Hi, I have two vm´s in azure and are in a domain, one with database and other with AOS, I have already installed with CU7, after that I downloaded demo data (bak) and restored in SQL. So I executed provision_user_by_partition script to change users for my domain. After that my AOS service not started. There were release.sql script when you download demo data, but it not exist more. Anybody know how I fix it? Is this procedure correct?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

Is there any message in the event log?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

First thanks all guys,

It´s a new installation with CU7 included, and I put demo data. I will install again, what sequence you advise to me? Install release 2012 without CU7, put demo data and after that install CU7? Besides fix user with provision user (sql script), what more I must to do?

Here are some events that occur after extract demo data

Object Server 01: Destroying cache objects for the main session.

Object Server 01: Exiting kernel types for the main session.

Object Server 01: Destroying user session with ID 1.

Object Server 01: The database AX4BCU7BD\MicrosoftDynamicsAX_model is not recognized as a model store.

Object Server 01: SQL diagnostics: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'intranet\axinst'.. Connect information was: Userid = [], Database = [MicrosoftDynamicsAX], Server = [AX4BCU7BD], DSN = [], Other = []

Object Server 01: Fatal SQL condition during login. Error message: "[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'intranet\axinst'."

Object Server 01: Server terminated unexpectedly with 90 exitcode.

Was this reply helpful? Yes No
Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

The error "Login failed for user 'intranet\axinst'" should be clear enough. I'm not sure what "database is not recognized as a model store" means, nevertheless let's solve the other problem first; they may be related.

I would reinstall AOS and let the installer to do everything needed in both the transactional and modelstore database. (I actually start with DB, since I got into similar troubles before).

Was this reply helpful? Yes No
Suggested answer

fsilva-jr 20 on at

Like (0)

Report

More about moving AX databases can be found here:

blogs.msdn.com/.../moving-between-microsoft-dynamics-ax-2012-environments.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

The user axinst have right permissions in SQL and domain, this message ocurred because this user not are in new database, but I changed this user to other that exist, I put message only to knowledge.

Yesterday I created a new VM with database only and other with AOS client in a domain, both are clean without data.

Now I looking for a way to restore this demo data, but my afraid is happen the same situation the last 3 installations before, because fault this release.sql script before run provision_user.sql .

I will try this tips guys.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I got the script release.sql with a Microsoft enginner, see below. But now the AOS service show other error.

Windows could not start the Microsoft Dynamics AX Object Server 6.2.$01-MicrosoftDynamicsAX on local computer. For more information, review the System Event Log. If this a non-Microsoft service, contact the service vendor, and refer to service-specific error code 100

Script release.sql

UPDATE USERINFO SET SID = 'S-1-5-21-836180139-1044439273-2747162012-1163', NETWORKALIAS = 'adminax12', NETWORKDOMAIN = 'intranet.ax4b', NAME = ''

UPDATE SYSBCPROXYUSERACCOUNT SET SID = 'S-1-5-21-836180139-1044439273-2747162012-1160', NETWORKALIAS = 'bcproxy12', NETWORKDOMAIN = 'intranet.ax4b'

UPDATE SYSUSERINFO SET SQMUSERGUID = '00000000-0000-0000-0000-000000000000'

DELETE FROM SYSSERVERCONFIG

DELETE FROM SYSSERVERSESSIONS

DELETE FROM SYSCLIENTSESSIONS

DELETE FROM SRSSERVERS

DELETE FROM BATCHSERVERCONFIG

DELETE FROM BATCHSERVERGROUP

DELETE FROM SYSUSERLOG

DELETE FROM BICONFIGURATION

DELETE FROM BIANALYSISSERVER

DELETE FROM SMMPHONEPARAMETERS

DELETE FROM EPGlobalParameters

DELETE FROM EPWebSiteParameters

Was this reply helpful? Yes No
Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

Please do what the error already asked you to do - look into the event log. It's not enough to know that there is an error, you need to know what the error is.

Also, are you sure that you set NetworkDomain, NetworkAlias and SID to values correct in your Active Directory?

Was this reply helpful? Yes No