can't add current login as user (more)

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
>.
>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!
>
>login
>a|||Right, and that's happened here before too, but we
reconciled those long ago. This is something new because
these accounts haven't been renamed since then, and I've
added them as users since then.

>--Original Message--
>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:
>
I
in
adding
won't
the
then
>.
>sql

can't add current login as user

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 MachCheck 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|||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:
>
login
I
a
the
>.
>|||Hi, I'd the same error when I tried to add an user group (domain user group)
to new login (sql server).
What I did was instead of clicking on be "..." button (browse no Name), I ty
ped in manually "BUILTIN\Users" (assuming I want to add "Users" user group)
and click "OK". and guess what? It works for me.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.