Post reply

login already has an account under different username

  • 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

     

  • 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!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply