Can't delete login

From: Shaun Stuart (sstuartA-TproNsOoSfPtAtMrainingD-O-Tcom)
Date: 12/30/02 

From: "Shaun Stuart" <sstuartA-TproNsOoSfPtAtMrainingD-O-Tcom>
Date: Mon, 30 Dec 2002 09:23:14 -0700

I'm trying to delete an old login and SQL refuses to let me. It returns the
following error:

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

If I go to the Corporate or Europe databases in Enterprise Manager, the user
list does not include this user.

Using Query Analyzer, I get the following in both the Corporate and Europe
databases:

sp_helplogins 'mcho'
LoginName SID
DefDBName DefLangName AUser ARemote
--------- ------------------------------------------------------------------
----------------------------------------------------------------------------
------------------------------ --------- -------------------- ----- -------
mcho 0x774D71CF7DEED411A87200D0B79E955A
pubs us_english yes no

(1 row(s) affected)

LoginName DBName UserName UserOrAlias
--------- ------------------ ---------- -----------
mcho Corporate \mcho User
mcho Europe \mcho User

(2 row(s) affected)

sp_helpuser 'mcho'
Server: Msg 15198, Level 16, State 1, Procedure sp_helpuser, Line 189
The name supplied (mcho) is not a user, role, or aliased login.

sp_helpuser '\mcho'
Server: Msg 15198, Level 16, State 1, Procedure sp_helpuser, Line 189
The name supplied (\mcho) is not a user, role, or aliased login.

sp_dropuser 'mcho'
Server: Msg 15008, Level 16, State 1, Procedure sp_dropuser, Line 12
User 'mcho' does not exist in the current database.

sp_dropuser '\mcho'
Server: Msg 15008, Level 16, State 1, Procedure sp_revokedbaccess, Line 31
User '\mcho' does not exist in the current database.

Any ideas? I'm running SQL Server 7.0 SP4 + hotfixes (Microsoft SQL Server
7.00 - 7.00.1077 (Intel X86))

Shaun

Relevant Pages

  • Re: Cant delete login
    ... I issued sp_dropalias 'mcho' against the Corporate and Europe ... Why did this show up as a User and not an Alias in ... Why did sp_helpuser say this was not an aliased login? ... > If I go to the Corporate or Europe databases in Enterprise Manager, ...
    (microsoft.public.sqlserver.security)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)