Re: can't add current login as user (more)

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 14:00:00 -0700

Check the article I just posted for you in the first message
on this (you can keep all these in the same thread...just
reply to the original to follow up and add additional info).
The only time I've run into something similar was with
accounts that were renamed.

-Sue

On Thu, 25 Mar 2004 11:32:05 -0800, "Sandy Mach"
<anonymous@discussions.microsoft.com> wrote:

>That's SQL Server 2000 (sorry!) and Windows (Server)
>2000... it's almost like SQL isn't reading from or
>synchronizing with Active Directory properly, but we can
>find no other indicator that there is a problem.
>
>Again, any help is greatly appreciated!
>
>
>>-----Original Message-----
>>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: Server Migration...
    ... The logins are in the master DB and the DTS packages are in msdb. ... Columnist, SQL Server Professional ... database between server including all Systems Databases, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server Logins do not have database access
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... created all user logins before restoring the databases. ... A few users are SQL Server logins. ...
    (microsoft.public.sqlserver.security)
  • Re: Moving SQL Objects
    ... Moving SQL Server databases to a new location with Detach/Attach ... Transfer Logins and Passwords Between Instances of SQL Server ... How to Resolve Permission Issues When a Database Is Moved Between SQL ...
    (microsoft.public.sqlserver.server)
  • Re: URGENT (again) :-)
    ... the system databases are special... ... > Using WITH MOVE in a Restore to a New Location with Detach/Attach ... > How To Transfer Logins and Passwords Between SQL Servers ... > Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving SQL Server Components
    ... Moving SQL Server databases to a new location with Detach/Attach ... Transfer Logins and Passwords Between Instances of SQL Server ... How to Resolve Permission Issues When a Database Is Moved Between SQL ...
    (microsoft.public.sqlserver.server)