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

All responses (5)

Answers (0)

WhiteOwl SPanchal 105 on at

Like (0)

Report

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

Issue is resolved !!!

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

navcodecrunch.blogspot.com/.../solution-of-error-while-restoring.html
WhiteOwl SPanchal 105 on at

Like (0)

Report

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

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?
WhiteOwl SPanchal 105 on at

Like (0)

Report

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

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.
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

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

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
Suggested answer

JAngle 89 on at

Like (0)

Report

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

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