hi,
I ref it
https://dynamicsessentials.net/2015/04/14/how-to-move-your-ax-2012-deployment-to-a-different-domain/
but, i can have 2000 later users in my domain.
Backup the MicrosoftDynamicsAX and MicrosoftDynamicsAX_model database.
Restore the backup database in my other domain(different domian) server.
so,In SQL Server USERINFO, I want to change the users SID from old-domain to new-domian.
I want use T-SQL to solve it.
so,I ref it.
https://sqlserver-help.com/tag/convert-sid/
but,the result is incorrect.
for ex)
query:
select dbo.fn_SIDToString(SUSER_SID('contoso\axaif'))
⇒Result:
S-1-5-21-3503383935-5084141-3467774935-1126
query:
C:\Windows\system32>wmic useraccount where (name='axaif' and domain='contoso') get name,sid
⇒Result:
Name SID
axaif S-1-5-21-3503383935-2353917331-3467774935-1126
I want the T-SQL script...help.
*This post is locked for comments