can't add current login as user

From: Sandy Mach (anonymous_at_discussions.microsoft.com)
Date: 03/25/04


Date: Thu, 25 Mar 2004 08:47:51 -0800

Hi all. I'm having problems trying to add a current login
as a user to any databases. The logins are there, but
when I try to give one access to another db, or even if I
try to add user from within the db itself, I get error
15401 (Windows NT user or group not found). I looked in
KB but could only find this error in reference to adding a
new login. As stated, the logins are already setup and
have been for about two years now, the system just won't
let me add them as users.

What really gets me is how SQL Server will let me use the
necessary tool to pick the login from the list, but then
it says it's not found. (???)

Thanks in advance for any help!
Sandy Mach



Relevant Pages

  • 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)
  • Re: Lost ability to login to secure database
    ... > to login and cannot open any of my secured databases. ... I assume you know the workgroup file that was used to secure your ... Create a desktop shortcut to open them. ...
    (microsoft.public.access.security)