Re: MSSQLServerADHelper is problem?

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

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

Try revoking the login and then re-add it and see if you can
add the login as a database user.
Is the a problem for all logins or just one or a few? Is it
a problem with trying to add them to any database or just
one specific database?

-Sue

On Thu, 25 Mar 2004 13:31:55 -0800, "Sandy Mach"
<anonymous@discussions.microsoft.com> wrote:

>Well I was just trying to find something... is there any
>way to see if it's working properly when it's supposed to
>be working? My gut tells me this problem has to do with
>AD somehow...
>
>Can you think of any other options or ways to fix?
>
>
>>-----Original Message-----
>>That's normal behavior. You can't start the service
>>manually. It runs when requested to by SQL Server service
>or
>>Analysis Server service and then stops running when it's
>>completed it's work.
>>
>>-Sue
>>
>>On Thu, 25 Mar 2004 12:27:49 -0800, "Sandy Mach"
>><anonymous@discussions.microsoft.com> wrote:
>>
>>>MSSQLServerADHelper isn't running and we can't get it to
>>>start. System Event Log says "The MSSQLServerADHelper
>>>service terminated with service-specific error
>3221225572."
>>>
>>>Any clues at all how to fix?
>>>
>>>
>>>>-----Original Message-----
>>>>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