Question

Sharepoint 2003

Active Directory, SharePoint, Microsoft

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 DOMAIN\user -newlogin DOMAIN\user [-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

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.