Error attempting to add server to Active Directory

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)
>
>.
>

Error Adding SQL Server to Active Directory

Hi,
I've just installed SQL 2000 SE on a server and specified seperate domain
accounts for the services to run under. Now when I go to the server
properties and the Active Directory tab to add the server to AD I get the
following error:
SQL Server Enterprise Manager could not add server '(local)' to Active
Directory. Error 22039: xpadsi.exe failed.
Anyone else had this problem?
Thanks - Dave.yes. did you ever work out how to fix it ?
"Dave Rhodes" wrote:

> Hi,
> I've just installed SQL 2000 SE on a server and specified seperate domain
> accounts for the services to run under. Now when I go to the server
> properties and the Active Directory tab to add the server to AD I get the
> following error:
> SQL Server Enterprise Manager could not add server '(local)' to Active
> Directory. Error 22039: xpadsi.exe failed.
> Anyone else had this problem?
> Thanks - Dave.
>
>

Error Adding SQL Server to Active Directory

Hi,
I've just installed SQL 2000 SE on a server and specified seperate domain
accounts for the services to run under. Now when I go to the server
properties and the Active Directory tab to add the server to AD I get the
following error:
SQL Server Enterprise Manager could not add server '(local)' to Active
Directory. Error 22039: xpadsi.exe failed.
Anyone else had this problem?
Thanks - Dave.yes. did you ever work out how to fix it ?
"Dave Rhodes" wrote:
> Hi,
> I've just installed SQL 2000 SE on a server and specified seperate domain
> accounts for the services to run under. Now when I go to the server
> properties and the Active Directory tab to add the server to AD I get the
> following error:
> SQL Server Enterprise Manager could not add server '(local)' to Active
> Directory. Error 22039: xpadsi.exe failed.
> Anyone else had this problem?
> Thanks - Dave.
>
>

Error Adding SQL Server to Active Directory

Hi,
I've just installed SQL 2000 SE on a server and specified seperate domain
accounts for the services to run under. Now when I go to the server
properties and the Active Directory tab to add the server to AD I get the
following error:
SQL Server Enterprise Manager could not add server '(local)' to Active
Directory. Error 22039: xpadsi.exe failed.
Anyone else had this problem?
Thanks - Dave.
yes. did you ever work out how to fix it ?
"Dave Rhodes" wrote:

> Hi,
> I've just installed SQL 2000 SE on a server and specified seperate domain
> accounts for the services to run under. Now when I go to the server
> properties and the Active Directory tab to add the server to AD I get the
> following error:
> SQL Server Enterprise Manager could not add server '(local)' to Active
> Directory. Error 22039: xpadsi.exe failed.
> Anyone else had this problem?
> Thanks - Dave.
>
>