NAV2013 - Error: no authorization after restore

nttis

Hi all,
we have a brand new NAV2013 installation.
For the first time we have to restore an existent DB coming from a different SQL instance in a different domain.

In the old NAV you could restore and immediatly set in the same client (classic) the user logins.
in NAV2013 we have not found a way to set the permission in the cside client (development environment), so when restoring from it, we cannot access via the RTC client to setup the users. The error is: "You are not authorized to sign in."
Obviously in the restored db our users (the domain is different!) are not present....

In a test environment (3 different servers -SQL, NavService, Client) we could install and access the Demo DB without problems.

thanks!

matteo_montanari

nttis wrote:

Hi all,
we have a brand new NAV2013 installation.
For the first time we have to restore an existent DB coming from a different SQL instance in a different domain.

In the old NAV you could restore and immediatly set in the same client (classic) the user logins.
in NAV2013 we have not found a way to set the permission in the cside client (development environment), so when restoring from it, we cannot access via the RTC client to setup the users. The error is: "You are not authorized to sign in."
Obviously in the restored db our users (the domain is different!) are not present....

In a test environment (3 different servers -SQL, NavService, Client) we could install and access the Demo DB without problems.

thanks!

Hi

You can try to delete directly on SQL every user on "User" table and every record on table "Access Control".
It's the standard Cronus DB configuration (without any user) so i think this will work...

Matteo

yukon

Hi All,

matteo montanari wrote:

nttis wrote:

Hi all,
we have a brand new NAV2013 installation.
For the first time we have to restore an existent DB coming from a different SQL instance in a different domain.

In the old NAV you could restore and immediatly set in the same client (classic) the user logins.
in NAV2013 we have not found a way to set the permission in the cside client (development environment), so when restoring from it, we cannot access via the RTC client to setup the users. The error is: "You are not authorized to sign in."
Obviously in the restored db our users (the domain is different!) are not present....

In a test environment (3 different servers -SQL, NavService, Client) we could install and access the Demo DB without problems.

thanks!

Hi

You can try to delete directly on SQL every user on "User" table and every record on table "Access Control".
It's the standard Cronus DB configuration (without any user) so i think this will work...

Matteo

We need to update/insert into 3 tables.
1.[User]
2.[Access Control]
3.[User Property] - (New table in 2013)

I updated above 3 tables when i face problem . After that everything is :thumbsup:

Noted: We can get SID from window but need to generated for [User Security ID] fld value.

Regards,
Yukon

nttis

You're right man! We have truncated the two tables and now with your solution it's working! Thank you very much but I cannot believe that this could be a standard way recommended by Microsoft to manage this common situation. We have previously guessed something of similar and tried to clean only the User table, and maybe for this the trick had not worked. We look forward to hear if MS will release instructions to accomplish this task in a smarter way.
Thanks!

mdPartnerNL

Don't think Ms will help. Have any instructions, steps.