While attempting to add a SQL Server to the Active Directory, I
received an error stating that the MSSQLServerADHelper service could
not be started. The service is set to manual startup. When I attempt
to start the service myself, I get the following error that I cannot
find any information on in the KB:
The MSSQLServerADHelp service terminated with the service-specific
error 3221225572.
Also searched for $C0000064 in hopes that the error was listed in hex,
to no avail.
Any ideas what the problem is?
Thanks,
Brandon
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)Issue appears to be related to security. I changed the SQLServer and
SQLAgent startup account to administrator and tried again, and it
successfully added itself to AD through Enterprise Manager.
I think the security for the old security account is messed up. I am
going to remove it and try again.
Brandon
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)|||please refer to:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/architec/8_ar_cs_9mhx.asp
this behaviour is by design, you cannot start
MSSQLServerADHelp service manually, it is started by sql
server or analyis services whenever needed and then stopes
it when done.
Make sure the start up account for MSSQLServerADHelp is
Local System, and also that the server is member of a AD
domain. and sql server service start up account should
have permission to start MSSQLServerADHelp service.
>--Original Message--
>While attempting to add a SQL Server to the Active
Directory, I
>received an error stating that the MSSQLServerADHelper
service could
>not be started. The service is set to manual startup.
When I attempt
>to start the service myself, I get the following error
that I cannot
>find any information on in the KB:
>The MSSQLServerADHelp service terminated with the service-
specific
>error 3221225572.
>Also searched for $C0000064 in hopes that the error was
listed in hex,
>to no avail.
>Any ideas what the problem is?
>Thanks,
>Brandon
>--
>"In the beginning the universe was created. This has
made a lot of
>people very angry, and has been widely regarded as a bad
move." -
>Douglas Noel Adams (1952-2001)
>
>.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment