Re: can't add current login as user

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

Date: Thu, 25 Mar 2004 13:56:19 -0700

Check the following KB article:
HOW TO: Troubleshoot Error 15401
http://support.microsoft.com/?id=324321

-Sue

On Thu, 25 Mar 2004 08:47:51 -0800, "Sandy Mach"
<anonymous@discussions.microsoft.com> wrote:

>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: Membership download
    ... SSIS task does not include the property for ALTER AUTHORIZATION ON SCHEMA. ... How to move databases between computers that are running SQL Server ... With SSIS transfer object task, if your destination server has no logins, ...
    (microsoft.public.sqlserver.dts)
  • Re: object level permissions being lost when migrating
    ... I first transferred the logins from the 2000 server to the 2005 server via ... I then restored the databases and re-synched the users via the ... Errors After Restoring Dump ...
    (microsoft.public.sqlserver.security)
  • 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: sql 2008 evaluation edition upgrade
    ... your databases that's why I told you about BACKUP command. ... If you want to transfer your Logins, you can use some scripts or SSIS' s ... restore logins. ...
    (microsoft.public.sqlserver.setup)
  • db_owners unable to see login list
    ... add new users to their databases, despite the fact that logins exist ... for these users on the server. ... look at the logins, the complete list is not presented to them. ... assign them to server-level security roles, ...
    (comp.databases.ms-sqlserver)