web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

User login issue after restoring DB from one Add on env to UAT on LCS

(0) ShareShare
ReportReport
Posted on by 2,059

Hi,

After we restore DB from one Environment to Another (in my case Add on SAT Env to the UAT env) the users are unable to login even though they are the same users on both the environment.

One solution is to delete and reimport user. But there are quite a few users and then applying roles to them is an added work.

Is there a better solution to fix this login issue? Any LCS tool available for this?

Appreciate any tips.

Best Regards,

I have the same question (0)
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    14,616 Super User 2025 Season 2 on at
    RE: User login issue after restoring DB from one Add on env to UAT on LCS

    Hi MYGz ,

    Once a refresh database process is done for self service environments, the admin for the target environment will be the only active user.

    Please check the to do list for refresh database on #DynFoTech dynfotech.com/.../

  • Verified answer
    André Arnaud de Calavon Profile Picture
    299,314 Super User 2025 Season 2 on at
    RE: User login issue after restoring DB from one Add on env to UAT on LCS

    Hi MYGz,

    Alireza is correct. Have you verified the enablement of the users? I usually used the Excel add-in or Power Automate to quickly enable the users again.

    If the users were enabled and not able to login, please update let us know.

  • Verified answer
    Suresh M. Parmar Profile Picture
    340 on at
    RE: User login issue after restoring DB from one Add on env to UAT on LCS

    Hi there,

    As a database restore process, some of the data will be not imported to the destination database, Users are part of it. Only Admin user will be enabled. By that only other users can be enabled.

    Please follow the below link.

    https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/import-database#data-elements-that-require-attention-after-import

    Hope this Helps You !!!

    Thanks !!!

  • MYGz Profile Picture
    2,059 on at
    RE: User login issue after restoring DB from one Add on env to UAT on LCS

    Thank you guys. Enabling the users worked. I was in a hurry the previous time so deleted and reimported users and reapplied the roles. I was sure that there has to be a better way.

    Andre Arnaud de Calavon Yeah, did it through excel add-in, changed the enabled column to TRUE.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,122

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 918 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 646 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans