Re: 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 10:17:19 -0700

Well, I issued sp_dropalias 'mcho' against the Corporate and Europe
databases and the alias was dropped and I was able to delete the login, but
several questions remain: Why did this show up as a User and not an Alias in
sp_helplogins? How could I have seen this alias using Enterprise Manager?
Why did sp_helpuser say this was not an aliased login?

Shaun

"Shaun Stuart" <sstuartA-TproNsOoSfPtAtMrainingD-O-Tcom> wrote in message
news:eO9Q6#BsCHA.844@TK2MSFTNGP10...
> 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

  • ODBC, alias an SQL Server Login error
    ... is aliased or mapped to a user in one or more databases. ... user or alias before dropping the login. ...
    (microsoft.public.sqlserver.programming)
  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... detected that this login has permissions....etc this login ... be mapped to dbo. ... sysusers in the user databases and syslogins in master. ... I have seen a windows group referred to as a LOGIN for sql server in the ...
    (microsoft.public.sqlserver.security)
  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... any of the databases. ... exist anywhere in sql server either. ... detected that this login has permissions....etc this login ... be mapped to dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: Two DB Owners
    ... full permissions in all databases. ... Note that the user will still be known as the 'dbo' user as long as the ... I need to add the login 'BUILTIN\Administrators' ... > 'DYNGRP' and 'BFGROUP' roles of the Dynamics and DAVCatalog databases. ...
    (microsoft.public.sqlserver.security)
  • Re: Random Login Failures
    ... setup a trace in Profiler to collect failed logins with these columns ... Analzy the trace after some failed login may help. ... that later I found out a report queried ALL user databases instead SOME ... primary database server hosting about 50 or so databases. ...
    (microsoft.public.sqlserver.server)