Updating the SID

While not a common activity, there are times you might moved your DAX database from one domain to another. This might be because of testing or because development is offsite. If this occurs you need to change the admin account in DAX to point to the new domain. Below are the steps needed to do this:

1. Open the command prompt

2. Type:

wmic path win32_useraccount where name=”{Domain user name}” get sid

3. Copy the SID

4. Open the SQL server and write following command to update current admin user:

update USERINFO
set SID = ‘<sid>’, NETWORKDOMAIN='<domain.com>’, NetworkAlias = ‘<domain user name>’ where ID=’Admin’