Re: Error 22042

From: Eric (anonymous_at_discussions.microsoft.com)
Date: 11/26/03 

Date: Wed, 26 Nov 2003 04:38:07 -0800

Yes it is. Itīs member of Domain Admins group, and Iīve
configured it as the account for SQL Service and SQL
Server Agent in another server in the same domain with no
trouble.

Eric.
>-----Original Message-----
>Is the domain account a member of the Local Admin group
on the server..?
>
>
>
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>
>"Eric" <anonymous@discussions.microsoft.com> wrote in
message
>news:064901c3b416$1409c290$a001280a@phx.gbl...
>> I have SQL server (Sp3a) installed in a Windows 2000
SP4.
>> Everytime I try to configure a domain account for SQL
>> Service or SQL Server Agent. I get this error: Error
>> 22042: xp_SetSQLSecurity() returned error -
>> 2147024890 'Invalid driver'. The extended stored
>> Procedure is defined by xpstar.dll I've tried replacing
it
>> with a copy from a server where I can correctly
configure
>> the domain account but the error keeps coming up.
>>
>> Any suggestions?
>>
>> Thanks
>> Eric.
>
>
>.
>

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • RE: MP Install issue
    ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)
  • Re: SQL Express Fails with Hardware Error
    ... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
    (microsoft.public.sqlserver.setup)
  • Re: Replication across non-trusted domains requires Win2k Application server and not Domain Controll
    ... you can do it by using SQL authentication instead of NT authentication. ... that the SQL Agent account on your subscriber has rights to read it. ... Or is it possible to install SQL server ... > upon a Windows 2K Domain Controller(Server with Active directory ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication across non-trusted domains requires Win2k Application server and not Domain Controll
    ... you can do it by using SQL authentication instead of NT authentication. ... that the SQL Agent account on your subscriber has rights to read it. ... Or is it possible to install SQL server ... > upon a Windows 2K Domain Controller(Server with Active directory ...
    (microsoft.public.sqlserver.connect)