{"id":646,"date":"2012-08-30T22:10:40","date_gmt":"2012-08-30T21:10:40","guid":{"rendered":"http:\/\/www.darrencoupland.com\/blog\/?p=646"},"modified":"2012-08-30T22:10:40","modified_gmt":"2012-08-30T21:10:40","slug":"updating-an-ax-users-sid-when-theyve-been-accidently-deleted-from-active-directory","status":"publish","type":"post","link":"https:\/\/www.darrencoupland.com\/blog\/2012\/08\/updating-an-ax-users-sid-when-theyve-been-accidently-deleted-from-active-directory\/","title":{"rendered":"Updating an AX users SID when they’ve been accidently deleted from Active Directory"},"content":{"rendered":"

If you ever find an AX user’s account has been accidently deleted from Active Directory then is recreated with the same user name but they cannot access AX this is because they now have a new Active Directory SID that doesn’t match the SID against their user in AX.<\/p>\n

This can be resolved by updating their SID in AX with the newly recreated user’s SID.<\/p>\n

 <\/p>\n

The Problem:<\/p>\n

“User1” was deleted in Active Directory, it was established that “User1” shouldn’t have been deleted, so “User1” was recreated. \u00a0Unfortunately “User1” couldn’t access AX though, they were receiving an Access Denied message.<\/p>\n

Resolution:<\/p>\n

First of all run the following powershell script (replace “User1” with your user) to find their SID<\/p>\n

$AdObj = New-Object System.Security.Principal.NTAccount('User1')\n$strSID = $AdObj.Translate([System.Security.Principal.SecurityIdentifier])\n$strSID.Value<\/pre>\n
 <\/p>\n
As you can see their SID is returned as S-1-5-21-1214440339-1788223648-682003330-48397<\/p>\n
\"\"<\/p>\n
 <\/p>\n
Using the SID returned by the Powershell script run the following SQL Script (replacing the \u00a0Database Name, SID and ID with yours) to update the newly created login’s SID<\/p>\n
UPDATE [MY_DAX09_DATABASE].[dbo].[USERINFO]\nSET SID = 'S-1-5-21-1214440339-1788223648-682003330-48397'\nWHERE ID = 'User1'<\/pre>\n
Note: ID is not usually the same as the users AD login name, in this example it happens to be. \u00a0Doing a simple select statement on the [UserInfo] table will establish the users ID that you need to use in the above SQL Statement.<\/p>\n
“User1” will now be able to access AX again.<\/p>\n","protected":false},"excerpt":{"rendered":"
If you ever find an AX user’s account has been accidently deleted from Active Directory then is recreated with the same user name but they cannot access AX this is because they now have a new Active Directory SID that doesn’t match the SID against their user in AX. This can be resolved by updating […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3],"tags":[29,8,59,25,28],"class_list":["post-646","post","type-post","status-publish","format-standard","hentry","category-dynamics-ax-2009","tag-administration","tag-ax2009","tag-dynamics-ax-2009","tag-scripts","tag-t-sql"],"_links":{"self":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/646","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/comments?post=646"}],"version-history":[{"count":3,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/646\/revisions"}],"predecessor-version":[{"id":661,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/646\/revisions\/661"}],"wp:attachment":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/media?parent=646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/categories?post=646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/tags?post=646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}