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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

can't login to environment after refresh database

(0) ShareShare
ReportReport
Posted on by 2,259

Hi all, 

we made a refresh to the database for dynamics 365 F&O,  as showing here ( https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/database-refresh )

after the finishing refreshing the test environment from Live we can't sing in with the users

we got this message 

You are not authorized to login with your current credentials. You will be redirected to the login page in a few seconds.

pastedimage1598429552312v1.png

can any one help with this

I have the same question (0)
  • Verified answer
    vinitgoyal2005 Profile Picture
    6,332 on at

    Hi,

    After DB refresh from Prod, all the users are always disabled except for Admin user. you need to log in with the admin user and enable other users after any config change required. Like any ISV setting and Azure app settings etc. You can also enable all of them from the SQL side quickly with 1 update query.

  • Verified answer
    mhdshb1 Profile Picture
    1,250 on at

    Hi, 

    Did you check if the users are enabled? 

    You can check that by logging in through the Admin account. 

    make sure you read this section in the article 

    https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/database-refresh#data-elements-that-arent-copied-during-refresh

    to open the environment for the users 

    https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/dbmovement-scenario-general-refresh#open-the-environment-to-users

    Regards,

    M

  • Verified answer
    WillWU Profile Picture
    22,361 on at

    Hi w.sallam,

    Please try to run the 'C:\AOSService\PackagesLocalDirectory\Bin\AdminUserProvisioning.exe' tool.

    If you're still getting the error after running, one of the possible cause would be this database hasn't been sync with your environment yet, please try synchronize the DB, then do an iisreset.

    Hope this helps.

  • w.sallam Profile Picture
    2,259 on at

    thanks all ,

    singing in with admin and re-enable the users

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans