Re: Error 22042

From: Ryan Waight (Ryan_Waight_at_nospam.hotmail.com)
Date: 11/26/03 

Date: Wed, 26 Nov 2003 13:01:07 -0000

There is a Kbase article on 22042, hopefully this will help :-

http://support.microsoft.com/default.aspx?scid=kb;en-us;299935 

-- 
HTH
Ryan Waight, MCDBA, MCSE
"Eric" <anonymous@discussions.microsoft.com> wrote in message
news:0ca001c3b41a$24b77ca0$a501280a@phx.gbl...
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: 0x80004005 - you need permission to view its data
    ... Based on the information in the "Security Account Delegation" topic in SQL ... When connecting to multiple servers, and with each server change, we need ... Establish a SPN for your domain account which will enable Kerberos ...
    (microsoft.public.sqlserver.security)
  • Re: ISP scenario for AD and DNS
    ... WSS needs a domain account to connect with a non-local SQL ... non-local SQL Server, so it has to be a member of a domain. ... Exchange does require Active Directory, but if your thinking of Exchange ...
    (microsoft.public.windows.server.dns)
  • Re: Security
    ... by running a job and my domain account which is also ... SA on both SQL servers by using exec xp_cmdshell 'dtsrun'. ... in the dts package connection is a SQL Login that is SA on the server it is ... >> connection to the other server uses to sysadmin. ...
    (microsoft.public.sqlserver.server)
  • Re: Jobs Failed do not work when scheduled done via DTS Scheduled Package
    ... EM/QA directly on the server? ... > Anything that was done via DTS' FAILS. ... > the account that is logged on is a domain account and we even made it ... the sql is set to use either sql or windows authentication. ...
    (microsoft.public.sqlserver.server)
  • Re: Error 22042
    ... Itīs member of Domain Admins group, ... configured it as the account for SQL Service and SQL ... Server Agent in another server in the same domain with no ...
    (microsoft.public.sqlserver.security)