Re: Error 22039 trying to add SQL 2K to AD

Sue,
Thanks for your response.
1) "permissions that matter but rather the permissions of the SQL Server
service account. " - Not sure how to answer this b/c I use Windows domain
login for connection. I use Administrator for this and have full access
rights.

2) "Sqlstp.log and Setup.log" - my programmer checked these and said all
was OK.

3) "There are issues with xpadsi.exe on domain controllers" - what kinds of
issues? where can I read about them.

4) What do I lose by not having SQL server registered with AD?

"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:hm51k112bk39ehbv0ih16bu3j9riufkgcv@xxxxxxxxxx
> With your posts it's hard to tell if you have two different
> issue or just one. If the service is not installing, that
> would be one issue.
> If the service is installed, on the permissions side it's
> not your permissions that matter but rather the permissions
> of the SQL Server service account.
> Make sure xpadsi.exe is in the correct folder.
> There are issues with xpadsi.exe on domain controllers.
> If you uninstalled and reinstalled, did you check the setup
> logs - Sqlstp.log and Setup.log
>
> -Sue
>
> On Sun, 2 Oct 2005 20:55:54 -0500, "Sydney Lotterby"
> <sydney@xxxxxxxxxxxxxx> wrote:
>
>>I upgraded SQL 2000 to sp4, tried to add registration to Active Directory
>>and get the following:
>>
>>SQL Server Enterprise Manager could not add server '....' to Active
>>Directory.
>>Error 22039: xpadsi.exe failed
>>
>>Any suggestions?
>>
>>btw I am logged in as Administrator on the srever itself and have Full
>>Rights.
>>
>


.

Relevant Pages

  • Re: xp_cmdshell right for non sysadmin
    ... You can get the error when the SQL Server service account ... does not have the necessary permissions to change security ...
    (microsoft.public.sqlserver.server)
  • Re: xp_cmdshell failed to execute because current security context
    ... The permissions needed are outlined in the KB that Uri posted. ... When you install SQL Server, you get a bunch of groups, one for each service for that instance. ... So you need to make sure that your service account is a member of this group. ... > ontario, canada ...
    (microsoft.public.sqlserver.server)
  • Re: Specifying a logon account for SQL Server 2005 services
    ... recommended way to define a service account, the SQL Server setup ... The second topic of these details which permissions the service account ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Using Network Service Account to remote SQL Server with WSS
    ... seems like a good idea and kb below has some detail on how to grant ... permissions in SQL Server by using Domain\Computername$ ... Saves manaully creating service account and having a password that should be ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: restoring
    ... It doesn't matter what *you* are logged in as. ... matter what account SQL Server is using. ... information regarding permissions needed etc for the service account. ... >> Does the service account for the SQL Server service have permissions on the share? ...
    (microsoft.public.sqlserver.server)