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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment