Update admin user in Dev box

Old is gold,

MS removed admin user provising tool, but there is an old way where you can still add your user as admin, 

Go to the VM and open SQL management Studio, 

Step 1: Find admin user rec id in USERINFO table, 

select  * from USERINFO

Step 2: Get SID from earlier Database for your user

select  * from USERINFO

where RECID = 53755554576

Step 3: Update new Database with below query 

update USERINFO

set NETWORKALIAS = 'deepak.agarwal@theaxapta.com',

sid = 'S-1-19-18-####-####-####5192'

where RECID = 53755554576

Make sur eof choosing right Database of each query and use the right recid and other values. 

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta