Post reply

Can''t add user

  • May 5, 2006 at 8:23 am

    #168127

    Hi there,

    It gives me an error message "User already exists" when adding a login user to a database. I surely deleted that user name in the db. That mean the deleted user is still some where in the db server. Is that called "wild/lost account" and how to list them and completely deleted them?

    Thanks in advance,

    Vincent

  • May 5, 2006 at 9:11 am

    #636282

    I have this issue some times too. In enterprise manager in the database under users the user us not shown, but when you try to add it states user exists.

     

    Use the T-sql commands to remove the users

    Use Mydatabase

    sp_dropuser 'MyUser'

  • May 5, 2006 at 9:51 am

    #636308

    It works. Thank you, Ray.

    Vincent.

     

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

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