Sharepoint 2003

100 pts.
Tags:
Active Directory
Microsoft
SharePoint
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
ASKED: January 20, 2008  10:33 AM
UPDATED: April 22, 2008  4:29 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following