login already has an account under different username

• Ritesh-123787

  SSC Veteran

  Points: 256

  More actions

  September 17, 2004 at 1:55 am

  #59424

  Hi All

  I am exporting data from one DB to another using DTS wizard. I hv used copy object option and I hv selected only tables option within Copy Object option, I hv ticked the few table which I want to copy. It starts copying the files but after completing certain % of task it gives me thr error

  "login already has an account under different username"

  What does this mean

  I have following users in my source DB

   

  dbo        sa

  ritesh     illusions\ritesh

  guest

   

  Can anyone tell me whats the problem is?

   

  Regards & Thanks

  Ritesh

• DSP-120308

  Hall of Fame

  Points: 3959

  More actions

  September 17, 2004 at 8:21 am

  #523506

  Ritesh,

  The DTS wizard is copying (or at least trying to :angry the logins along with the tables. I would create a new DTS package and use the "Copy SQL SERVER Objects" Task. After setting the source and destination properties you get to the "Copy" tab. On this tab clear the checkbox for "Use Default Option" and then go into the Options screen and clear the database users and database permissions checkboxes. Of course you will want to take care of those settings on the destination once the transfer is done!