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’

Advertisements

One thought on “Updating the SID

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s