April 14, 2009 at 9:13 am
when i try and transfer logins from 2000 to 2005 i get error.
using article http://support.microsoft.com/kb/246133 method 2.
error is Msg 15433, Level 16, State 1, Line 9
Supplied parameter sid is in use.
April 14, 2009 at 12:46 pm
I believe that would indicate the sid of one of the logins you are trying to transfer is already in use for an existing user on your destination server. You'll have to determine where the conflict is an delete the user, or not transfer the new user.
select * from syslogins
April 15, 2009 at 2:07 am
Yes, this error message indicates that,a different login exists with the same SID value on the destination server as the one you are trying to add.
You have first look into the output file from the source server and compare it with the sysxlogins table on the destination server and then find out the respective login with the same @sid which already exists. Then it would be your option to either delete the exisiting one and recreating new login or leave the login as it without making any changes.
-Rajini
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply