ODBC, alias an SQL Server Login error

From: Dave (dave_at_groupfive.net)
Date: 03/12/04 

Date: 12 Mar 2004 08:30:09 -0800

The message that I got was:

[Microsoft][ODBC SQL Server Driver][SQL Server Login]

is aliased or mapped to a user in one or more databases. Drop the
user or alias before dropping the login.

I am trying to create all new accounts for a new database. Is this
referring to the SA account? If anyone could assist me with this I
would appreciate it very much.

Thanks.

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)
  • removing BUILTINAdmin access to databases
    ... denied access to databases by default, ... but in the login properties this login is still listed as having ... 'dbo' at some level, although I'm unable to find a clue to this in the ... Dropping the login works fine. ...
    (microsoft.public.sqlserver.security)
  • 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)