Error Restoring AX 2012 R3 Databases on Different Domain

(1) Share

Report

Posted on by Muhammad Haroon

2,382

Hello,

I have restored AX 2012 R3 databases (Business Data, Model, and Baseline) on an Azure-hosted machine in a different domain from where the backups were taken. After restore, when I try to start the AX service, I receive the following error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'dbo.XU_GetSchemaVersion'_*.

I have applied the following fixes but unfortunately these steps haven't resolved the issue:

1. Updated the SID for the Admin account within the UserInfo table.
2. Granted read, write, and execute permissions for all three databases to the AOS service account.
3. Executed the Initialize-AXModelStore command and the AxUtil schema command.

I would appreciate any assistance in troubleshooting this problem.

Thank you in advance for your time and support.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, the similar issue has been raised in the LCS resource, you may refer to it. If the issue persists, you can submit to Microsoft for inverstigation:

Details for issue 611216 (dynamics.com)

Was this reply helpful? Yes No