Re: can't add current login as user

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


Date: Thu, 25 Mar 2004 13:26:19 -0800

As previously stated, I read that article before posting
here, and it refers only to adding new logins... these
LOGINs are already existing within SQL Server Security
Logins. SQL Server will not let me grant any of the
current logins access to any additional databases (will
NOT let me add current LOGIN as NEW USER), and the only
error I get is that 15401 which doesn't make sense in this
situation.

SQL Server lets me use the drop-down box showing current
logins to choose as new user, so it's finding them fine
there. It lets me go thru all the motions until it comes
time to save, then it says it can't find the user or group
(when IT let me find them thru its own nav tools!!).

Any other suggestions?
   

>-----Original Message-----
>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: 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 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)