Small and medium business | Business Central, N...

Facing issue while running RTC after restoring the DB of Dynamics NAV (Upgradation Process)

(0) Share

Report

Posted on by WhiteOwl SPanchal

105

Hello Business Central/NAV Dev,

We are working on the up-gradation of Dynamics NAV to Business Central cloud. So, what we did for the up-gradation process.

Process::

Installed the NAV 15,

Restore the client database

Clear the data of table as per below:

USE [Your New Database Name]
GO
delete from [dbo].[User]
delete from [dbo].[Access Control]
delete from [dbo].[User Property]
delete from [dbo].[Page Data Personalization]
delete from [dbo].[User Default Style Sheet]
delete from [dbo].[User Metadata]
delete from [dbo].[User Personalization]

After that we have created NAV user using power shell as per below link:

https://microsoft-dynamics-nav.blogspot.com/2017/03/you-do-not-have-access-to-microsoft.html

After all the scenario we are still facing the strange error like:

So, Anyone have any idea about thise above issue?

Thanks In Advance

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

The mentioned script doesn’t contain user setup. Maybe clear that down too?

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you please try changing the Authentication to Windows to login ?

Also assign your windows user permission on your SQL database.

Once you login you can create your user with Username and password with appropriate permissions.

Thanks,

Chris

Was this reply helpful? Yes No
WhiteOwl SPanchal 105 on at

Like (0)

Report
Copy link

Link copied!

Hello @Josh Anglesea, Thanks for the reply,

I have already deleted the user setup as well after i get this error. but still facing the same issue.

Was this reply helpful? Yes No
WhiteOwl SPanchal 105 on at

Like (0)

Report
Copy link

Link copied!

Hello @Chris D'silva, Than you for the response,

I have gave the right/roles to the window user and after that i have tried with Service Account as windows but still facing the same issue.

Also tried with NT Authority/Network but still not getting any solution.

Is there other way to do this?

Was this reply helpful? Yes No
WhiteOwl SPanchal 105 on at

Like (0)

Report
Copy link

Link copied!

Issue is resolved !!!

I have also created one post for solution. Here is the link:

navcodecrunch.blogspot.com/.../solution-of-error-while-restoring.html

Was this reply helpful? Yes No