100 pts.
 Sharepoint 2003
Dear All, I have renamed one user in AD, thus the logon information is changed. The user couldn't access sharepoint. In sharepoint the user was deleted and the new user added, still same problem. SP3 downloaded and I used 'migrate' method. stsadm -o migrateuser -oldlogin DOMAINuser -newlogin DOMAINuser [-ignoresidhistory] The following error appears: user cannot be found. The problem I think maybe the old SID is still there but it is not associated with the old login and the new login is associated with the same SID. How can I resolve this issue, many thanks

Software/Hardware used:
ASKED: January 20, 2008  10:33 AM
UPDATED: April 22, 2008  4:29 PM

Answer Wiki:
DISCLAIMER: This answer involves manually editing the Sharepoint site information database. In SQL Server Enterprise Manager, open the _SITE database for your Sharepoint implementation. Query the UserInfo table in the following manner: SELECT * FROM UserInfo WHERE (tp_Login = 'oldlogin') (You can first use SELECT TOP 5 * FROM UserInfo to see how the logins are formatted.) For each entry of the old login, replace the value (tp_Login) with the new login. Solved our "User cannot be found" errors related to a change in AD not correctly propagated to Sharepoint.
Last Wiki Answer Submitted:  April 22, 2008  4:29 pm  by  Xcelling   15 pts.
All Answer Wiki Contributors:  Xcelling   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _