Re-enabling users in SAT after Production Database copy

Whenever you request a database copy over from the Production environment to Standard Acceptance Test, the database copy over will disable all your users.

There is the long winded way to fix this - you could log into D365, go to your users screen and enable each one individually.  Apart from taking a long time to do, it requires that you are the administrator - as only the Admin gets access to D365.

A more convenient way is the following:

a) Go to your SAT environment. 

i) In the full details page note the password for the sqladmin user

ii) also note the Sql Server\Database Name for the instance with the comment (APPDBSERVER)

b) RDP to the environment using your axlocaladmin credentials (NOTE: in the new update to lcs you might first have to grant you ip address RDP rights)

c) Open SQL Server Management Studio:

i) in the server name put the name of the database server (from aii) suffixed with .database.windows.net

ii) in login put sqladmin

iii) in password put your password (from ai)

d) locate the axdb database and run the following command (assuming you want to enable all users)

update userinfo set enable = 1

That's it.  You've enabled all the users and probably saved yourself a lot of time.  Once you have all the credentials, you can probably do away with the RDP step and use your local SSMS thus allowing you to automate this step (in particular if you want to do it for a select group of users).