Re: Error 22039 trying to add SQL 2K to AD
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Wed, 05 Oct 2005 20:31:00 -0600
1. Services run under security credentials. SQL Server runs
as a service. You assign a login for this service to run
under. You can view the account being used by SQL Server to
run under Services. Look at the LogOn tab when view the SQL
Server service and it will tell you what SQL Server runs
under.
2. That applied to one of your threads where you indicated
the service wasn't installing.
3. There are probably knowledge base articles on it. Search
the Knowledge base for SQL Server only and the exact phrase
domain controller. There are a lot of security issues as
well if you are installing SQL Server on a domain
controller.
4. Look for the books online topics:
Active Directory Integration
MSSQLServerADHelper Service
-Sue
On Wed, 5 Oct 2005 11:38:01 -0500, "Sydney Lotterby"
<sydney@xxxxxxxxxxxxxx> wrote:
>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.
>>>
>>
>
.
- References:
- Error 22039 trying to add SQL 2K to AD
- From: Sydney Lotterby
- Re: Error 22039 trying to add SQL 2K to AD
- From: Sue Hoegemeier
- Re: Error 22039 trying to add SQL 2K to AD
- From: Sydney Lotterby
- Error 22039 trying to add SQL 2K to AD
- Prev by Date: Re: SQL 2000 enterprise - 2 processors
- Next by Date: Re: After install new SQL 2005 CTP September, local database doesn't w
- Previous by thread: Re: Error 22039 trying to add SQL 2K to AD
- Next by thread: RESTORE DATABASE WITH RECOVERY very slow
- Index(es):
Relevant Pages
|
