I would like to rename a login SAMPLE-IT\bean to NEWDOMAIN\bean, but i get this message:
"The name change cannot be performed because the SID of the new name does not match the old SID of the principal."
the command is : alter login [SAMPLE-IT\bean] with name=[NEWDOMAIN\bean]
server is sql2005 std (initial base)
what can i do ( there are lot of db on this instance and there are lot of instance where I have to change the domain of the user...) ... and there are lot of user whom I have to change it...:-(
thnx
Csaba
A similar thread appears here:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2052035&SiteID=17
I suggest to install SQL Server SP2 and read the articles linked the thread above.
No comments:
Post a Comment