Results 1 to 6 of 6

Thread: Error 15174

  1. #1
    Join Date
    Dec 2003
    Posts
    181

    Error 15174

    I was trying to clean the Logins and saw some userid that were old then when I tried to delete I got this message:

    Error 15174:Login 'userid' is aliased or mapped to a user in one or more database(s). Drop the user or alias before dropping the login. Database name: ABC

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Use sp_dropuser in database ABC to drop the user first, then drop the login.

  3. #3
    Join Date
    Dec 2003
    Posts
    181
    It worked on all except one that says:
    User 'userid' does not exist in the current database.

    I tried deleting from Security and got this message "the specified @owner_login_name('userid') does not exist.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Do you see the user in sysusers table?

    If yes, then it may be an alias in the database. Try sp_dropalias.

  5. #5
    Join Date
    Mar 2013
    Posts
    1
    What is this alias in the database, i got to know abt this 1st time.
    Apart from sysuser where i can see database alias.

  6. #6
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Don't revive a 8 years old thread if you have a question.

    Database alias was a concept in SQL 6.x, you should not use it anymore.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •